VIEW: APPS.PA_FP_PERIODS_TMP_V

Source

View Text - Preformatted

SELECT distinct pa_fp_view_plans_pub.Get_Fp_Period_Type(), paperiod.period_year, decode(pa_fp_view_plans_pub.Get_Fp_Period_Type(),'PA',paperiod.period_name,'GL',gl_period_name), decode(pa_fp_view_plans_pub.Get_Fp_Period_Type(),'PA',paperiod.PA_START_DATE,'GL',gl_Start_date), decode(pa_fp_view_plans_pub.Get_Fp_Period_Type(),'PA',paperiod.PA_end_DATE,'GL',gl_end_date) FROM pa_periods_v paperiod, pa_budget_versions pbv, pa_projects ppa WHERE pbv.budget_version_id = pa_fp_view_plans_pub.Get_Version_ID() and pbv.project_id = ppa.project_id and ppa.org_id=paperiod.org_id

View Text - HTML Formatted

SELECT DISTINCT PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, PAPERIOD.PERIOD_YEAR
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PERIOD_NAME
, 'GL'
, GL_PERIOD_NAME)
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PA_START_DATE
, 'GL'
, GL_START_DATE)
, DECODE(PA_FP_VIEW_PLANS_PUB.GET_FP_PERIOD_TYPE()
, 'PA'
, PAPERIOD.PA_END_DATE
, 'GL'
, GL_END_DATE)
FROM PA_PERIODS_V PAPERIOD
, PA_BUDGET_VERSIONS PBV
, PA_PROJECTS PPA
WHERE PBV.BUDGET_VERSION_ID = PA_FP_VIEW_PLANS_PUB.GET_VERSION_ID()
AND PBV.PROJECT_ID = PPA.PROJECT_ID
AND PPA.ORG_ID=PAPERIOD.ORG_ID