APPS.PJI_PJP_SUM_MAIN dependencies on PA_PROJ_ELEMENT_VERSIONS

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

3109: l_extraction_type = 'INCREMENTAL' or
3110: l_extraction_type = 'PARTIAL') then
3111:
3112: -- identify all projects that fit the concurrent program parameters
3113: /* No Need to check in the table PA_PROJ_ELEMENT_VERSIONS Bug 5057835
3114: begin -- bug 5356051
3115:
3116: select 'Y'
3117: into l_prg_exists

Line 3120: from PA_PROJ_ELEMENT_VERSIONS proj

3116: select 'Y'
3117: into l_prg_exists
3118: from DUAL
3119: where exists (select 1
3120: from PA_PROJ_ELEMENT_VERSIONS proj
3121: where proj.OBJECT_TYPE = 'PA_STRUCTURES' and
3122: proj.PRG_GROUP is not null and
3123: ROWNUM = 1);
3124:

Line 3323: PA_PROJ_ELEMENT_VERSIONS proj

3319: into
3320: l_prg_exists
3321: from
3322: PJI_PJP_PROJ_BATCH_MAP map,
3323: PA_PROJ_ELEMENT_VERSIONS proj
3324: where
3325: map.WORKER_ID = p_worker_id and
3326: map.PROJECT_ID = proj.PROJECT_ID and
3327: proj.OBJECT_TYPE = 'PA_STRUCTURES' and

Line 3375: PA_PROJ_ELEMENT_VERSIONS ver1,

3371: distinct
3372: ver2.PROJECT_ID
3373: from
3374: PJI_PJP_PROJ_BATCH_MAP map,
3375: PA_PROJ_ELEMENT_VERSIONS ver1,
3376: PA_PROJ_ELEMENT_VERSIONS ver2
3377: where
3378: map.WORKER_ID = p_worker_id and
3379: ver1.PROJECT_ID = map.PROJECT_ID and

Line 3376: PA_PROJ_ELEMENT_VERSIONS ver2

3372: ver2.PROJECT_ID
3373: from
3374: PJI_PJP_PROJ_BATCH_MAP map,
3375: PA_PROJ_ELEMENT_VERSIONS ver1,
3376: PA_PROJ_ELEMENT_VERSIONS ver2
3377: where
3378: map.WORKER_ID = p_worker_id and
3379: ver1.PROJECT_ID = map.PROJECT_ID and
3380: ver1.PRG_GROUP is not null and