APPS.PJI_PJP_SUM_ROLLUP dependencies on PA_RBS_DENORM

Line 2242: from PA_RBS_DENORM rbs

2238: from
2239: DUAL
2240: where
2241: not exists (select 1
2242: from PA_RBS_DENORM rbs
2243: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
2244:
2245: end if;
2246:

Line 2359: from PA_RBS_DENORM rbs

2355: from
2356: DUAL
2357: where
2358: not exists (select 1
2359: from PA_RBS_DENORM rbs
2360: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
2361:
2362: end if;
2363:

Line 2436: from PA_RBS_DENORM rbs

2432: from
2433: DUAL
2434: where
2435: not exists (select 1
2436: from PA_RBS_DENORM rbs
2437: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
2438:
2439: end loop;
2440:

Line 2951: from PA_RBS_DENORM rbs

2947: from
2948: DUAL
2949: where
2950: not exists (select 1
2951: from PA_RBS_DENORM rbs
2952: where rbs.STRUCT_VERSION_ID = c.RBS_VERSION_ID);
2953:
2954: end loop;
2955:

Line 3154: PA_RBS_DENORM rbs,

3150: 0 SUB_LEVEL_OLD,
3151: 'X' SUB_LEAF_FLAG,
3152: +1 SIGN
3153: from
3154: PA_RBS_DENORM rbs,
3155: PJI_PA_PROJ_EVENTS_LOG log
3156: where
3157: log.WORKER_ID = p_worker_id and
3158: log.EVENT_TYPE = 'RBS_PUSH' and

Line 11444: PA_RBS_DENORM rbs

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
11446: l_extraction_type <> 'RBS' and
11447: rbs.STRUCT_VERSION_ID = ss.RBS_VERSION_ID and
11448: pjp1.WORKER_ID = p_worker_id and

Line 11899: PA_RBS_DENORM rbs

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
11901: -- l_extraction_type <> 'RBS' and
11902: rbs.STRUCT_VERSION_ID = ss.RBS_VERSION_ID and
11903: -- pjp1.WORKER_ID = p_worker_id and

Line 16869: PA_RBS_DENORM pa,

16865: l_creation_date,
16866: l_created_by,
16867: l_last_update_login
16868: from
16869: PA_RBS_DENORM pa,
16870: PJI_RBS_DENORM pji
16871: where
16872: nvl(pa.STRUCT_VERSION_ID, -1)
16873: = nvl(pji.STRUCT_VERSION_ID (+), -1) and

Line 16922: PA_RBS_DENORM den,

16918: l_creation_date,
16919: l_created_by,
16920: l_last_update_login
16921: from
16922: PA_RBS_DENORM den,
16923: (
16924: select
16925: distinct
16926: log.EVENT_OBJECT

Line 16986: PA_RBS_DENORM den,

16982: l_creation_date,
16983: l_created_by,
16984: l_last_update_login
16985: from
16986: PA_RBS_DENORM den,
16987: (
16988: select
16989: distinct
16990: EVENT_OBJECT,

Line 17041: PA_RBS_DENORM den

17037: l_creation_date,
17038: l_created_by,
17039: l_last_update_login
17040: from
17041: PA_RBS_DENORM den
17042: where
17043: den.STRUCT_VERSION_ID = g_rbs_version;
17044:
17045: -- delete from PJI_RBS_DENORM_DELTA_T;