APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on PA_ORGFCST_PERIODS_TMP_V

Line 237: FROM pa_orgfcst_periods_tmp_v

233:
234: CURSOR C1(l_start_date IN DATE, l_rownum IN NUMBER) IS
235: SELECT * FROM(
236: SELECT start_date,end_date
237: FROM pa_orgfcst_periods_tmp_v
238: WHERE start_date >= l_start_date
239: order by start_date
240: )
241: where rownum <= l_rownum;

Line 380: FROM pa_orgfcst_periods_tmp_v

376:
377: CURSOR C_forward(l_start_date IN DATE) IS
378:
379: SELECT start_date
380: FROM pa_orgfcst_periods_tmp_v
381: WHERE start_date > l_start_date
382: order by start_date;
383:
384:

Line 388: FROM pa_orgfcst_periods_tmp_v

384:
385: CURSOR C_backward(l_start_date IN DATE) IS
386:
387: SELECT start_date
388: FROM pa_orgfcst_periods_tmp_v
389: WHERE start_date < l_start_date
390: order by start_date desc;
391:
392: BEGIN