APPS.PJI_PJP_SUM_DENORM dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 1941: PJI_PJP_PROJ_BATCH_MAP map,

1937: ver.element_version_id,
1938: ver.parent_structure_version_id,
1939: ver.prg_group
1940: from
1941: PJI_PJP_PROJ_BATCH_MAP map,
1942: PA_PROJ_ELEMENT_VERSIONS ver
1943: where
1944: p_extraction_type in ('FULL', 'UPGRADE') and
1945: ver.object_type = 'PA_STRUCTURES' and

Line 1967: PJI_PJP_PROJ_BATCH_MAP map

1963: distinct
1964: ver.prg_group
1965: from
1966: PA_PROJ_ELEMENT_VERSIONS ver,
1967: PJI_PJP_PROJ_BATCH_MAP map
1968: where
1969: p_extraction_type in ('FULL', 'UPGRADE') and
1970: ver.object_type = 'PA_STRUCTURES' and
1971: ver.prg_group is not null and

Line 2071: update PJI_PJP_PROJ_BATCH_MAP

2067: l_project_id := prg_node.PROJECT_ID;
2068:
2069: elsif (l_project_id <> prg_node.PROJECT_ID) then
2070:
2071: update PJI_PJP_PROJ_BATCH_MAP
2072: set PJI_PROJECT_STATUS = 'C'
2073: where WORKER_ID = p_worker_id and
2074: PROJECT_ID = l_project_id;
2075:

Line 2535: update PJI_PJP_PROJ_BATCH_MAP

2531: END LOOP; -- FOR PRG_NODE
2532:
2533: if (p_extraction_type = 'FULL' or p_extraction_type = 'UPGRADE') then
2534:
2535: update PJI_PJP_PROJ_BATCH_MAP
2536: set PJI_PROJECT_STATUS = null
2537: where WORKER_ID = p_worker_id and
2538: PJI_PROJECT_STATUS = 'C';
2539:

Line 4628: pji_pjp_proj_batch_map map

4624: )
4625: )
4626: and exists (select 1 /* Modified for bug 11843459 */
4627: from pa_rbs_prj_assignments assignments,
4628: pji_pjp_proj_batch_map map
4629: where map.project_id = assignments.project_id
4630: and assignments.rbs_version_id = pvt_nodes1.rbs_version_id)
4631: UNION ALL
4632: select