APPS.PA_FP_VIEW_PLANS_PUB dependencies on PA_FP_PERIODS_TMP_V

Line 2089: FROM pa_fp_periods_tmp_v

2085:
2086: CURSOR C1(l_start_date IN DATE, l_rownum IN NUMBER) IS
2087: SELECT * FROM(
2088: SELECT start_date,end_date
2089: FROM pa_fp_periods_tmp_v
2090: WHERE start_date >= l_start_date
2091: order by start_date
2092: )
2093: where rownum <= l_rownum;

Line 2249: FROM pa_fp_periods_tmp_v

2245:
2246: CURSOR C_forward(l_start_date IN DATE) IS
2247:
2248: SELECT start_date, end_date
2249: FROM pa_fp_periods_tmp_v
2250: WHERE start_date > l_start_date and
2251: start_date between pa_fp_view_plans_pub.G_FP_PLAN_START_DATE and
2252: pa_fp_view_plans_pub.G_FP_PLAN_END_DATE
2253: order by start_date;

Line 2259: FROM pa_fp_periods_tmp_v

2255:
2256: CURSOR C_backward(l_start_date IN DATE) IS
2257:
2258: SELECT start_date
2259: FROM pa_fp_periods_tmp_v
2260: WHERE start_date < l_start_date and
2261: start_date between pa_fp_view_plans_pub.G_FP_PLAN_START_DATE and
2262: pa_fp_view_plans_pub.G_FP_PLAN_END_DATE
2263: order by start_date desc;