SELECT period_type, period_year, period_name, start_date, end_date from pa_fp_periods_tmp_v WHERE start_date >=pa_fp_view_plans_pub.Get_Plan_Start_Date() and end_date <= pa_fp_view_plans_pub.Get_Plan_End_Date()
View Text - HTML Formatted
SELECT PERIOD_TYPE , PERIOD_YEAR , PERIOD_NAME , START_DATE , END_DATE FROM PA_FP_PERIODS_TMP_V WHERE START_DATE >=PA_FP_VIEW_PLANS_PUB.GET_PLAN_START_DATE() AND END_DATE <= PA_FP_VIEW_PLANS_PUB.GET_PLAN_END_DATE()