DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_ROLLUP_LEVEL_STATUS

Line 1781: from PJI_ROLLUP_LEVEL_STATUS

1777: where log.WORKER_ID = p_worker_id and
1778: log.EVENT_TYPE = 'RBS_DELETE');
1779:
1780: delete
1781: from PJI_ROLLUP_LEVEL_STATUS
1782: where RBS_VERSION_ID in (select distinct
1783: decode(log.EVENT_TYPE,
1784: 'RBS_PUSH', log.ATTRIBUTE2,
1785: 'RBS_DELETE', log.EVENT_OBJECT)

Line 11441: PJI_ROLLUP_LEVEL_STATUS ss,

11437: sum(pjp1.CUSTOM14) CUSTOM14,
11438: sum(pjp1.CUSTOM15) CUSTOM15
11439: from
11440: PJI_FP_AGGR_PJP1 pjp1,
11441: PJI_ROLLUP_LEVEL_STATUS ss,
11442: PJI_PJP_RBS_HEADER rbs_hdr,
11443: PJI_PJP_WBS_HEADER wbs_hdr,
11444: PA_RBS_DENORM rbs
11445: where

Line 11896: PJI_ROLLUP_LEVEL_STATUS ss,

11892: sum(pjp1.CUSTOM14) CUSTOM14,
11893: sum(pjp1.CUSTOM15) CUSTOM15
11894: from
11895: PJI_FP_AGGR_PJP1_T pjp1,
11896: PJI_ROLLUP_LEVEL_STATUS ss,
11897: PJI_PJP_RBS_HEADER rbs_hdr,
11898: PJI_PJP_WBS_HEADER wbs_hdr,
11899: PA_RBS_DENORM rbs
11900: where