Create view

Create or replace view 

(PLAN_PERIOD_TYPE, PERIOD_PROFILE_ID, GL_PERIOD_TYPE, NUMBER_OF_PERIODS, 
PERIOD_SET_NAME)

AS
(SELECT pppp.PLAN_PERIOD_TYPE, pppp.PERIOD_PROFILE_ID, pppp.GL_PERIOD_TYPE, pppp.NUMBER_OF_PERIODS, pppp.PERIOD_SET_NAME from pa_proj_period_profiles pppp, pa_budget_versions pbv WHERE pbv.budget_version_id = pa_fin_plan_view_global.Get_Version_ID() and pppp.PERIOD_PROFILE_ID = pbv.PERIOD_PROFILE_ID)