APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_FP_PERIODS_TMP_V

Line 2200: FROM pa_fp_periods_tmp_v

2196:
2197: CURSOR C1(l_start_date IN DATE, l_rownum IN NUMBER) IS
2198: SELECT * FROM(
2199: SELECT start_date,end_date
2200: FROM pa_fp_periods_tmp_v
2201: WHERE start_date >= l_start_date
2202: order by start_date
2203: )
2204: where rownum <= l_rownum;

Line 2360: FROM pa_fp_periods_tmp_v

2356:
2357: CURSOR C_forward(l_start_date IN DATE) IS
2358:
2359: SELECT start_date, end_date
2360: FROM pa_fp_periods_tmp_v
2361: WHERE start_date > l_start_date and
2362: start_date between pa_fp_view_plans_pub.G_FP_PLAN_START_DATE and
2363: pa_fp_view_plans_pub.G_FP_PLAN_END_DATE
2364: order by start_date;

Line 2370: FROM pa_fp_periods_tmp_v

2366:
2367: CURSOR C_backward(l_start_date IN DATE) IS
2368:
2369: SELECT start_date
2370: FROM pa_fp_periods_tmp_v
2371: WHERE start_date < l_start_date and
2372: start_date between pa_fp_view_plans_pub.G_FP_PLAN_START_DATE and
2373: pa_fp_view_plans_pub.G_FP_PLAN_END_DATE
2374: order by start_date desc;