APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_PROJECTS_ALL

Line 20: -- pa_projects_all and passed to Get_Revenue_Generation_Method.

16: p_debug_mode => p_pa_debug_mode);
17: END IF;
18:
19: -- Bug 4711164: Previously, distribution_rule was selected from
20: -- pa_projects_all and passed to Get_Revenue_Generation_Method.
21: -- However, it turns out that the lower level API ignores this
22: -- parameter value and derives the value on its own. Code to get
23: -- the distribution_rule has been removed to improve performance.
24:

Line 335: FROM pa_periods_all p, pa_projects_all proj

331: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
332:
333: SELECT p.period_name
334: INTO l_period_name
335: FROM pa_periods_all p, pa_projects_all proj
336: WHERE p.org_id = l_fp_cols_rec.x_org_id
337: AND proj.project_id = l_fp_cols_rec.x_project_id
338: AND proj.start_date between p.start_date and p.end_date;
339:

Line 349: FROM gl_period_statuses g, pa_projects_all proj

345: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
346:
347: SELECT g.period_name
348: INTO l_period_name
349: FROM gl_period_statuses g, pa_projects_all proj
350: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
351: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
352: AND g.adjustment_period_flag = 'N'
353: AND proj.project_id = l_fp_cols_rec.x_project_id

Line 666: FROM pa_periods_all p, pa_projects_all proj

662: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
663:
664: SELECT p.period_name, NVL(proj.completion_date, trunc(SYSDATE))
665: INTO l_etc_to_period, l_proj_comp_date
666: FROM pa_periods_all p, pa_projects_all proj
667: WHERE NVL(proj.completion_date, trunc(SYSDATE)) between p.start_date and p.end_date
668: AND p.org_id = l_fp_cols_rec.x_org_id
669: AND proj.project_id = l_fp_cols_rec.x_project_id;
670:

Line 684: FROM gl_period_statuses g, pa_projects_all proj

680: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
681:
682: SELECT g.period_name, NVL(proj.completion_date, trunc(SYSDATE))
683: INTO l_etc_to_period, l_proj_comp_date
684: FROM gl_period_statuses g, pa_projects_all proj
685: WHERE g.application_id = PA_PERIOD_PROCESS_PKG.Application_id
686: AND g.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
687: AND g.adjustment_period_flag = 'N'
688: AND proj.project_id = l_fp_cols_rec.x_project_id