APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_BUDGET_VERSIONS

Line 78: insert into pa_budget_versions_olap_tmp1

74: g_equip_resclass_code VARCHAR2(8) := 'EQUIP';
75: g_people_resclass_code VARCHAR2(8) := 'PEOPLE';
76:
77: BEGIN
78: insert into pa_budget_versions_olap_tmp1
79: (project_id ,
80: budget_version_id ,
81: PROJFUNC_CURRENCY_CODE,
82: PROJECT_CURRENCY_CODE

Line 88: from pa_budget_versions b, pa_projects_all p, pa_pjt_proj_batch batch

84: select p.project_id,
85: b.budget_version_id,
86: p.PROJFUNC_CURRENCY_CODE,
87: p.PROJECT_CURRENCY_CODE
88: from pa_budget_versions b, pa_projects_all p, pa_pjt_proj_batch batch
89: where b.olap_change_flag = 'Y'
90: and b.project_id = p.project_id
91: and p.project_id = batch.project_id;
92:

Line 93: insert into pa_budget_versions_olap_tmp2

89: where b.olap_change_flag = 'Y'
90: and b.project_id = p.project_id
91: and p.project_id = batch.project_id;
92:
93: insert into pa_budget_versions_olap_tmp2
94: (curr_type,
95: project_id,
96: budget_version_id,
97: currency_code

Line 100: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

96: budget_version_id,
97: currency_code
98: )
99: select 'ALL', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE
100: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
101: where b.project_id = p.project_id
102: and p.PROJFUNC_CURRENCY_CODE = p.PROJECT_CURRENCY_CODE
103: UNION
104: select 'PFC', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE

Line 105: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

101: where b.project_id = p.project_id
102: and p.PROJFUNC_CURRENCY_CODE = p.PROJECT_CURRENCY_CODE
103: UNION
104: select 'PFC', p.project_id, b.budget_version_id, p.PROJFUNC_CURRENCY_CODE
105: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
106: where b.project_id = p.project_id
107: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE
108: UNION
109: select 'PC', p.project_id, b.budget_version_id, p.PROJECT_CURRENCY_CODE

Line 110: from pa_budget_versions_olap_tmp1 b, pa_projects_all p

106: where b.project_id = p.project_id
107: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE
108: UNION
109: select 'PC', p.project_id, b.budget_version_id, p.PROJECT_CURRENCY_CODE
110: from pa_budget_versions_olap_tmp1 b, pa_projects_all p
111: where b.project_id = p.project_id
112: and p.PROJFUNC_CURRENCY_CODE <> p.PROJECT_CURRENCY_CODE;
113:
114:

Line 172: pa_budget_versions bv -- @pjdev115 bv

168: , 'N')
169: , 'N'
170: ) lp_flag
171: FROM
172: pa_budget_versions bv -- @pjdev115 bv
173: , pa_proj_fp_options fpo -- @pjdev115 fpo
174: , pa_projects_all ppa -- @pjdev115 ppa
175: , pa_budget_versions_olap_tmp1 b1
176: WHERE 1=1

Line 175: , pa_budget_versions_olap_tmp1 b1

171: FROM
172: pa_budget_versions bv -- @pjdev115 bv
173: , pa_proj_fp_options fpo -- @pjdev115 fpo
174: , pa_projects_all ppa -- @pjdev115 ppa
175: , pa_budget_versions_olap_tmp1 b1
176: WHERE 1=1
177: AND ppa.project_id = bv.project_id
178: AND bv.budget_version_id = b1.budget_version_id
179: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 427: pa_budget_versions_olap_tmp2 b ,

423: ,DECODE (b1.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code
424: -- , nvl(p1.cbs_version_id,-1) cbs_version_id --satya
425: -- , nvl(ra.cbs_element_id,-1) cbs_element_id
426: from
427: pa_budget_versions_olap_tmp2 b ,
428: pa_budget_versions b1,
429: pa_resource_assignments ra,
430: pa_budget_lines bl,
431: pji_time_cal_period per,

Line 428: pa_budget_versions b1,

424: -- , nvl(p1.cbs_version_id,-1) cbs_version_id --satya
425: -- , nvl(ra.cbs_element_id,-1) cbs_element_id
426: from
427: pa_budget_versions_olap_tmp2 b ,
428: pa_budget_versions b1,
429: pa_resource_assignments ra,
430: pa_budget_lines bl,
431: pji_time_cal_period per,
432: pa_projects_all p1,

Line 673: pa_budget_versions_olap_tmp2 b ,

669: ,DECODE (b1.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code
670: -- , nvl(p1.cbs_version_id,-1) cbs_version_id --satya
671: -- , nvl(ra.cbs_element_id,-1) cbs_element_id
672: from
673: pa_budget_versions_olap_tmp2 b ,
674: pa_budget_versions b1,
675: pa_resource_assignments ra,
676: pa_budget_lines bl,
677: pji_time_cal_period per,

Line 674: pa_budget_versions b1,

670: -- , nvl(p1.cbs_version_id,-1) cbs_version_id --satya
671: -- , nvl(ra.cbs_element_id,-1) cbs_element_id
672: from
673: pa_budget_versions_olap_tmp2 b ,
674: pa_budget_versions b1,
675: pa_resource_assignments ra,
676: pa_budget_lines bl,
677: pji_time_cal_period per,
678: pa_projects_all p1,