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 336: FROM pa_periods_all p, pa_projects_all proj

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

Line 350: FROM gl_period_statuses g, pa_projects_all proj

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

Line 667: FROM pa_periods_all p, pa_projects_all proj

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

Line 685: FROM gl_period_statuses g, pa_projects_all proj

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