DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_RBS_VERSIONS_B

Line 106: PA_RBS_VERSIONS_B ver

102: log.ATTRIBUTE20
103: from
104: PJI_PJP_PROJ_BATCH_MAP map,
105: PA_PJI_PROJ_EVENTS_LOG log,
106: PA_RBS_VERSIONS_B ver
107: where
108: map.WORKER_ID = p_worker_id and
109: log.EVENT_TYPE in (-- 'WBS_CHANGE', -- disable bulk processing
110: -- 'WBS_PUBLISH', -- of WBS events

Line 688: PA_RBS_VERSIONS_B ver

684: (
685: select
686: ver.RBS_VERSION_ID
687: from
688: PA_RBS_VERSIONS_B ver
689: where
690: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
691: ver.RBS_HEADER_ID) and
692: ver.STATUS_CODE = 'FROZEN'

Line 705: PA_RBS_VERSIONS_B ver

701: (
702: select
703: ver.RBS_VERSION_ID
704: from
705: PA_RBS_VERSIONS_B ver
706: where
707: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
708: ver.RBS_HEADER_ID)
709: ) and

Line 719: PA_RBS_VERSIONS_B ver

715: (
716: select
717: ver.RBS_VERSION_ID
718: from
719: PA_RBS_VERSIONS_B ver
720: where
721: ver.RBS_HEADER_ID = nvl(l_rbs_header_id,
722: ver.RBS_HEADER_ID) and
723: ver.STATUS_CODE = 'FROZEN'

Line 1089: PA_RBS_VERSIONS_B rbs

1085: log.ATTRIBUTE20
1086: from
1087: PJI_PA_PROJ_EVENTS_LOG log,
1088: PA_RBS_PRJ_ASSIGNMENTS rbs_prj,
1089: PA_RBS_VERSIONS_B rbs
1090: where
1091: log.WORKER_ID = p_worker_id and
1092: log.EVENT_TYPE = 'RBS_PUSH' and
1093: rbs.RBS_VERSION_ID = log.ATTRIBUTE2 and

Line 2822: PA_RBS_VERSIONS_B hdr

2818: from
2819: PJI_XBS_DENORM_DELTA prg,
2820: PJI_PJP_RBS_HEADER sup_rbs_hdr,
2821: PA_PROJ_ELEMENT_VERSIONS sub_ver,
2822: PA_RBS_VERSIONS_B hdr
2823: where
2824: prg.STRUCT_TYPE = 'PRG' and
2825: prg.SUP_ID <> prg.SUB_ID and
2826: prg.SIGN = 1 and