DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 4975: from PJI_ROLLUP_LEVEL_STATUS

4971: where log.WORKER_ID = p_worker_id and
4972: log.EVENT_TYPE = 'RBS_DELETE');
4973:
4974: delete
4975: from PJI_ROLLUP_LEVEL_STATUS
4976: where RBS_VERSION_ID in (select distinct
4977: decode(log.EVENT_TYPE,
4978: 'RBS_PUSH', log.ATTRIBUTE2,
4979: 'RBS_DELETE', log.EVENT_OBJECT)

Line 13557: PJI_ROLLUP_LEVEL_STATUS ss,

13553: sum(pjp1.CUSTOM14) CUSTOM14,
13554: sum(pjp1.CUSTOM15) CUSTOM15
13555: from
13556: PJI_FP_AGGR_PJP1 pjp1,
13557: PJI_ROLLUP_LEVEL_STATUS ss,
13558: PJI_PJP_RBS_HEADER rbs_hdr,
13559: PJI_PJP_WBS_HEADER wbs_hdr,
13560: PA_RBS_DENORM rbs
13561: where

Line 14012: PJI_ROLLUP_LEVEL_STATUS ss,

14008: sum(pjp1.CUSTOM14) CUSTOM14,
14009: sum(pjp1.CUSTOM15) CUSTOM15
14010: from
14011: PJI_FP_AGGR_PJP1_T pjp1,
14012: PJI_ROLLUP_LEVEL_STATUS ss,
14013: PJI_PJP_RBS_HEADER rbs_hdr,
14014: PJI_PJP_WBS_HEADER wbs_hdr,
14015: PA_RBS_DENORM rbs
14016: where