APPS.PA_FP_CALC_UTILS dependencies on PA_PROJECTS_ALL

Line 18: g_project_name pa_projects_all.segment1%type;

14: g_budget_version_type Varchar2(100);
15: g_budget_version_name Varchar2(250);
16: g_etc_start_date Date;
17: g_wp_version_flag Varchar2(10);
18: g_project_name pa_projects_all.segment1%type;
19: g_project_id Number;
20: g_ciid Number;
21: g_Plan_Class_Type Varchar2(50);
22: g_project_currency_code Varchar2(50);

Line 69: ,pa_projects_all ppa

65: 'REVENUE',ppfo.revenue_time_phased_code,
66: ppfo.all_time_phased_code) time_phased_code
67: FROM gl_sets_of_books gsb
68: ,pa_implementations_all pia
69: ,pa_projects_all ppa
70: ,pa_budget_versions pbv
71: ,pa_proj_fp_options ppfo
72: WHERE ppa.project_id = pbv.project_id
73: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 105: ,pa_projects_all pp

101: ,decode(fpt.plan_class_code,'BUDGET'
102: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
103: FROM pa_proj_fp_options pfo
104: ,pa_budget_versions bv
105: ,pa_projects_all pp
106: ,pa_fin_plan_types_b fpt
107: WHERE pfo.fin_plan_version_id = bv.budget_version_id
108: AND bv.project_id = pp.project_id
109: AND bv.budget_version_id = p_budget_version_id

Line 4245: ,pa_projects_all ppa

4241: ,gsb.accounted_period_type accounted_period_type
4242: ,pia.pa_period_type pa_period_type
4243: FROM gl_sets_of_books gsb
4244: ,pa_implementations_all pia
4245: ,pa_projects_all ppa
4246: ,pa_budget_versions pbv
4247: ,pa_proj_fp_options ppfo
4248: WHERE ppa.project_id = pbv.project_id
4249: AND pbv.budget_version_id = ppfo.fin_plan_version_id