VIEW: APPS.PA_FP_PERIODS_PL_V

Source

View Text - Preformatted

SELECT period_type, period_year, period_name, start_date, end_date from pa_orgfcst_periods_tmp_v WHERE start_date >=pa_fin_plan_view_global.Get_Plan_Start_Date() and end_date <= pa_fin_plan_view_global.Get_Plan_End_Date()

View Text - HTML Formatted

SELECT PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NAME
, START_DATE
, END_DATE
FROM PA_ORGFCST_PERIODS_TMP_V
WHERE START_DATE >=PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_START_DATE()
AND END_DATE <= PA_FIN_PLAN_VIEW_GLOBAL.GET_PLAN_END_DATE()