APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_RBS_DENORM

Line 5436: from PA_RBS_DENORM rbs

5432: from
5433: DUAL
5434: where
5435: not exists (select 1
5436: from PA_RBS_DENORM rbs
5437: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
5438:
5439: end if;
5440:

Line 5553: from PA_RBS_DENORM rbs

5549: from
5550: DUAL
5551: where
5552: not exists (select 1
5553: from PA_RBS_DENORM rbs
5554: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
5555:
5556: end if;
5557:

Line 5630: from PA_RBS_DENORM rbs

5626: from
5627: DUAL
5628: where
5629: not exists (select 1
5630: from PA_RBS_DENORM rbs
5631: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
5632:
5633: end loop;
5634:

Line 6205: from PA_RBS_DENORM rbs

6201: from
6202: DUAL
6203: where
6204: not exists (select 1
6205: from PA_RBS_DENORM rbs
6206: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
6207:
6208: end loop;
6209:

Line 6408: PA_RBS_DENORM rbs,

6404: 0 SUB_LEVEL_OLD,
6405: 'X' SUB_LEAF_FLAG,
6406: +1 SIGN
6407: from
6408: PA_RBS_DENORM rbs,
6409: PJI_PA_PROJ_EVENTS_LOG log
6410: where
6411: log.WORKER_ID = p_worker_id and
6412: log.EVENT_TYPE = 'RBS_PUSH' and

Line 13560: PA_RBS_DENORM rbs

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
13562: l_extraction_type <> 'RBS' and
13563: rbs.STRUCT_VERSION_ID = ss.RBS_VERSION_ID and
13564: pjp1.WORKER_ID = p_worker_id and

Line 14015: PA_RBS_DENORM rbs

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
14017: -- l_extraction_type <> 'RBS' and
14018: rbs.STRUCT_VERSION_ID = ss.RBS_VERSION_ID and
14019: -- pjp1.WORKER_ID = p_worker_id and

Line 19051: PA_RBS_DENORM pa,

19047: l_creation_date,
19048: l_created_by,
19049: l_last_update_login
19050: from
19051: PA_RBS_DENORM pa,
19052: PJI_RBS_DENORM pji
19053: where
19054: nvl(pa.STRUCT_VERSION_ID, -1)
19055: = nvl(pji.STRUCT_VERSION_ID (+), -1) and

Line 19142: PA_RBS_DENORM den,

19138: l_creation_date,
19139: l_created_by,
19140: l_last_update_login
19141: from
19142: PA_RBS_DENORM den,
19143: (
19144: select
19145: distinct
19146: log.EVENT_OBJECT

Line 19208: PA_RBS_DENORM den,

19204: l_creation_date,
19205: l_created_by,
19206: l_last_update_login
19207: from
19208: PA_RBS_DENORM den,
19209: (
19210: select
19211: distinct
19212: EVENT_OBJECT,

Line 19301: PA_RBS_DENORM den

19297: l_creation_date,
19298: l_created_by,
19299: l_last_update_login
19300: from
19301: PA_RBS_DENORM den
19302: where
19303: den.STRUCT_VERSION_ID = g_rbs_version;
19304:
19305: -- delete from PJI_RBS_DENORM_DELTA_T;