DBA Data[Home] [Help]

APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_BUDGET_VERSIONS_OLAP_TMP2

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