APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_RBS_VERSIONS_B

Line 3062: PA_RBS_VERSIONS_B ver

3058: log.ATTRIBUTE20
3059: from
3060: PJI_PJP_PROJ_BATCH_MAP map,
3061: PA_PJI_PROJ_EVENTS_LOG log,
3062: PA_RBS_VERSIONS_B ver
3063: where
3064: map.WORKER_ID = p_worker_id and
3065: log.EVENT_TYPE in (-- 'WBS_CHANGE', -- disable bulk processing
3066: -- 'WBS_PUBLISH', -- of WBS events

Line 3213: PA_RBS_VERSIONS_B rbs,

3209: rbs.RBS_VERSION_ID
3210: from
3211: PJI_PJP_PROJ_BATCH_MAP map,
3212: PA_PROJECTS_ALL prj,
3213: PA_RBS_VERSIONS_B rbs,
3214: PA_PJI_PROJ_EVENTS_LOG log
3215: where
3216: map.WORKER_ID = p_worker_id and
3217: prj.PROJECT_ID = map.PROJECT_ID and

Line 3668: PA_RBS_VERSIONS_B ver

3664: (
3665: select
3666: ver.RBS_VERSION_ID
3667: from
3668: PA_RBS_VERSIONS_B ver
3669: where
3670: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
3671: ver.RBS_HEADER_ID) and
3672: ver.STATUS_CODE = 'FROZEN'

Line 3685: PA_RBS_VERSIONS_B ver

3681: (
3682: select
3683: ver.RBS_VERSION_ID
3684: from
3685: PA_RBS_VERSIONS_B ver
3686: where
3687: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
3688: ver.RBS_HEADER_ID)
3689: ) and

Line 3699: PA_RBS_VERSIONS_B ver

3695: (
3696: select
3697: ver.RBS_VERSION_ID
3698: from
3699: PA_RBS_VERSIONS_B ver
3700: where
3701: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
3702: ver.RBS_HEADER_ID) and
3703: ver.STATUS_CODE = 'FROZEN'

Line 4168: PA_RBS_VERSIONS_B rbs

4164: log.ATTRIBUTE20
4165: from
4166: PJI_PA_PROJ_EVENTS_LOG log,
4167: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
4168: PA_RBS_VERSIONS_B rbs
4169: where
4170: log.WORKER_ID = p_worker_id and
4171: log.EVENT_TYPE = 'RBS_PUSH' and
4172: rbs.RBS_VERSION_ID = log.ATTRIBUTE2 and

Line 6076: PA_RBS_VERSIONS_B hdr

6072: from
6073: PJI_XBS_DENORM_DELTA prg,
6074: PJI_PJP_RBS_HEADER sup_rbs_hdr,
6075: PA_PROJ_ELEMENT_VERSIONS sub_ver,
6076: PA_RBS_VERSIONS_B hdr
6077: where
6078: prg.STRUCT_TYPE = 'PRG' and
6079: prg.SUP_ID <> prg.SUB_ID and
6080: prg.SIGN = 1 and