DBA Data[Home] [Help]

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 62: ,pa_projects_all ppa

58: 'REVENUE',ppfo.revenue_time_phased_code,
59: ppfo.all_time_phased_code) time_phased_code
60: FROM gl_sets_of_books gsb
61: ,pa_implementations_all pia
62: ,pa_projects_all ppa
63: ,pa_budget_versions pbv
64: ,pa_proj_fp_options ppfo
65: WHERE ppa.project_id = pbv.project_id
66: AND pbv.budget_version_id = ppfo.fin_plan_version_id

Line 98: ,pa_projects_all pp

94: ,decode(fpt.plan_class_code,'BUDGET'
95: ,decode(bv.wp_version_flag,'Y','WORKPLAN',fpt.plan_class_code),fpt.plan_class_code) Plan_Class_Type
96: FROM pa_proj_fp_options pfo
97: ,pa_budget_versions bv
98: ,pa_projects_all pp
99: ,pa_fin_plan_types_b fpt
100: WHERE pfo.fin_plan_version_id = bv.budget_version_id
101: AND bv.project_id = pp.project_id
102: AND bv.budget_version_id = p_budget_version_id

Line 4216: ,pa_projects_all ppa

4212: ,gsb.accounted_period_type accounted_period_type
4213: ,pia.pa_period_type pa_period_type
4214: FROM gl_sets_of_books gsb
4215: ,pa_implementations_all pia
4216: ,pa_projects_all ppa
4217: ,pa_budget_versions pbv
4218: ,pa_proj_fp_options ppfo
4219: WHERE ppa.project_id = pbv.project_id
4220: AND pbv.budget_version_id = ppfo.fin_plan_version_id