APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_BUDGET_VERSIONS_OLAP_TMP1

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 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 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.