APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 3036: /* No Need to check in the table PA_PROJ_ELEMENT_VERSIONS Bug 5057835

3032: l_extraction_type = 'INCREMENTAL' or
3033: l_extraction_type = 'PARTIAL') then
3034:
3035: -- identify all projects that fit the concurrent program parameters
3036: /* No Need to check in the table PA_PROJ_ELEMENT_VERSIONS Bug 5057835
3037: begin -- bug 5356051
3038:
3039: select 'Y'
3040: into l_prg_exists

Line 3043: from PA_PROJ_ELEMENT_VERSIONS proj

3039: select 'Y'
3040: into l_prg_exists
3041: from DUAL
3042: where exists (select 1
3043: from PA_PROJ_ELEMENT_VERSIONS proj
3044: where proj.OBJECT_TYPE = 'PA_STRUCTURES' and
3045: proj.PRG_GROUP is not null and
3046: ROWNUM = 1);
3047:

Line 3183: PA_PROJ_ELEMENT_VERSIONS proj

3179: into
3180: l_prg_exists
3181: from
3182: PJI_PJP_PROJ_BATCH_MAP map,
3183: PA_PROJ_ELEMENT_VERSIONS proj
3184: where
3185: map.WORKER_ID = p_worker_id and
3186: map.PROJECT_ID = proj.PROJECT_ID and
3187: proj.OBJECT_TYPE = 'PA_STRUCTURES' and

Line 3232: PA_PROJ_ELEMENT_VERSIONS ver1,

3228: distinct
3229: ver2.PROJECT_ID
3230: from
3231: PJI_PJP_PROJ_BATCH_MAP map,
3232: PA_PROJ_ELEMENT_VERSIONS ver1,
3233: PA_PROJ_ELEMENT_VERSIONS ver2
3234: where
3235: map.WORKER_ID = p_worker_id and
3236: ver1.PROJECT_ID = map.PROJECT_ID and

Line 3233: PA_PROJ_ELEMENT_VERSIONS ver2

3229: ver2.PROJECT_ID
3230: from
3231: PJI_PJP_PROJ_BATCH_MAP map,
3232: PA_PROJ_ELEMENT_VERSIONS ver1,
3233: PA_PROJ_ELEMENT_VERSIONS ver2
3234: where
3235: map.WORKER_ID = p_worker_id and
3236: ver1.PROJECT_ID = map.PROJECT_ID and
3237: ver1.PRG_GROUP is not null and