APPS.PJI_PJP_SUM_DENORM dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 329: from PJI_PA_PROJ_EVENTS_LOG i_log,

325: decode( invert.id,
326: 1, i_log.event_object,
327: 2, i_log.attribute2
328: ) event_object_id
329: from PJI_PA_PROJ_EVENTS_LOG i_log,
330: (
331: select 1 id
332: from dual
333: UNION ALL

Line 372: from PJI_PA_PROJ_EVENTS_LOG i_log,

368: decode( invert.id,
369: 1, i_log.event_object,
370: 2, i_log.attribute1
371: ) event_object_id
372: from PJI_PA_PROJ_EVENTS_LOG i_log,
373: (
374: select 1 id
375: from dual
376: UNION ALL

Line 444: from PJI_PA_PROJ_EVENTS_LOG i_log

440: (
441: select
442: distinct
443: i_log.ATTRIBUTE1
444: from PJI_PA_PROJ_EVENTS_LOG i_log
445: where 1=1
446: and i_log.worker_id = P_WORKER_ID
447: and i_log.event_type = 'PRG_CHANGE'
448: and i_log.event_object = -1

Line 501: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which PRG/WBS

497: --use this parameter for now
498: --
499: --
500:
501: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which PRG/WBS
502: -- data to process. ***
503:
504: prg_denorm(
505: p_worker_id,

Line 1550: from PJI_PA_PROJ_EVENTS_LOG

1546: from PA_RBS_DENORM
1547: where STRUCT_VERSION_ID in
1548: (
1549: select EVENT_OBJECT
1550: from PJI_PA_PROJ_EVENTS_LOG
1551: where 1=1
1552: and EVENT_TYPE = 'PJI_RBS_CHANGE'
1553: and WORKER_ID = P_WORKER_ID
1554: );

Line 1563: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which RBS

1559: -- EVENT_TYPE = 'PJI_RBS_CHANGE' ==> EVENT_OBJECT = structure version
1560: --
1561: --
1562: --
1563: -- *** Use PJI_PA_PROJ_EVENTS_LOG *** to determine which RBS
1564: -- data to process. ***
1565: --
1566:
1567: rbs_denorm(

Line 1939: from PJI_PA_PROJ_EVENTS_LOG i_log,

1935: decode( invert.id,
1936: 1, i_log.event_object,
1937: 2, i_log.attribute1
1938: ) event_object_id
1939: from PJI_PA_PROJ_EVENTS_LOG i_log,
1940: (
1941: select 1 id
1942: from dual
1943: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')

Line 1974: from PJI_PA_PROJ_EVENTS_LOG i_log,

1970: decode( invert.id,
1971: 1, i_log.event_object,
1972: 2, i_log.attribute1
1973: ) event_object_id
1974: from PJI_PA_PROJ_EVENTS_LOG i_log,
1975: (
1976: select 1 id
1977: from dual
1978: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')

Line 4448: from PJI_PA_PROJ_EVENTS_LOG

4444: into l_rbs_level_id
4445: from PA_RBS_ELEMENTS pvt_level,
4446: (
4447: select distinct event_type, event_object
4448: from PJI_PA_PROJ_EVENTS_LOG
4449: where 1=1
4450: and event_type = 'PJI_RBS_CHANGE'
4451: and worker_id = P_WORKER_ID
4452: ) log

Line 4563: from PJI_PA_PROJ_EVENTS_LOG log1

4559: (
4560: select
4561: distinct
4562: log1.event_type, log1.event_object
4563: from PJI_PA_PROJ_EVENTS_LOG log1
4564: where 1=1
4565: and log1.event_type = 'PJI_RBS_CHANGE'
4566: and worker_id = P_WORKER_ID
4567: ) log11