APPS.PJI_PJP_SUM_DENORM dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 1881: PJI_PJP_PROJ_BATCH_MAP map,

1877: ver.element_version_id,
1878: ver.parent_structure_version_id,
1879: ver.prg_group
1880: from
1881: PJI_PJP_PROJ_BATCH_MAP map,
1882: PA_PROJ_ELEMENT_VERSIONS ver
1883: where
1884: p_extraction_type in ('FULL', 'UPGRADE') and
1885: ver.object_type = 'PA_STRUCTURES' and

Line 1907: PJI_PJP_PROJ_BATCH_MAP map

1903: distinct
1904: ver.prg_group
1905: from
1906: PA_PROJ_ELEMENT_VERSIONS ver,
1907: PJI_PJP_PROJ_BATCH_MAP map
1908: where
1909: p_extraction_type in ('FULL', 'UPGRADE') and
1910: ver.object_type = 'PA_STRUCTURES' and
1911: ver.prg_group is not null and

Line 2011: update PJI_PJP_PROJ_BATCH_MAP

2007: l_project_id := prg_node.PROJECT_ID;
2008:
2009: elsif (l_project_id <> prg_node.PROJECT_ID) then
2010:
2011: update PJI_PJP_PROJ_BATCH_MAP
2012: set PJI_PROJECT_STATUS = 'C'
2013: where WORKER_ID = p_worker_id and
2014: PROJECT_ID = l_project_id;
2015:

Line 2475: update PJI_PJP_PROJ_BATCH_MAP

2471: END LOOP; -- FOR PRG_NODE
2472:
2473: if (p_extraction_type = 'FULL' or p_extraction_type = 'UPGRADE') then
2474:
2475: update PJI_PJP_PROJ_BATCH_MAP
2476: set PJI_PROJECT_STATUS = null
2477: where WORKER_ID = p_worker_id and
2478: PJI_PROJECT_STATUS = 'C';
2479:

Line 4534: pji_pjp_proj_batch_map map,

4530: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
4531: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
4532: -- pvt_nodes.rbs_group
4533: from PA_RBS_ELEMENTS pvt_nodes1,
4534: pji_pjp_proj_batch_map map,
4535: pa_rbs_prj_assignments assignments
4536: where 1=1
4537: and P_EXTRACTION_TYPE = 'FULL'
4538: and pvt_nodes1.user_created_flag = 'N'