APPS.PJI_LAUNCH_UPP_MAIN dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 1049: from PA_PJI_PROJ_EVENTS_LOG log

1045: into l_prg_event_exists
1046: from dual
1047: where exists
1048: ( select 'x'
1049: from PA_PJI_PROJ_EVENTS_LOG log
1050: where
1051: log.EVENT_TYPE = 'PRG_CHANGE' and
1052: log.EVENT_OBJECT <> -1 and
1053: i.PRG_GROUP in (log.EVENT_OBJECT, log.ATTRIBUTE1)

Line 2334: PA_PJI_PROJ_EVENTS_LOG LOG ,

2330: ver.PRG_GROUP ,
2331: - 1 project_id ,
2332: -1 prg_level
2333: FROM
2334: PA_PJI_PROJ_EVENTS_LOG LOG ,
2335: PA_PROJ_ELEMENT_VERSIONS ver
2336: WHERE
2337: ver.object_type = 'PA_STRUCTURES' AND
2338: log.EVENT_TYPE = 'PRG_CHANGE' AND

Line 2360: PA_PJI_PROJ_EVENTS_LOG LOG

2356: - 1,
2357: to_number(log.attribute1),
2358: - 1
2359: FROM
2360: PA_PJI_PROJ_EVENTS_LOG LOG
2361: WHERE
2362: log.EVENT_TYPE = 'PRG_CHANGE' AND
2363: log.EVENT_OBJECT = - 1
2364: AND NOT EXISTS

Line 2388: PA_PJI_PROJ_EVENTS_LOG LOG

2384: - 1,
2385: to_number(log.attribute1),
2386: -1
2387: FROM
2388: PA_PJI_PROJ_EVENTS_LOG LOG
2389: WHERE
2390: log.EVENT_TYPE IN ('RBS_ASSOC', 'RBS_PRG' )
2391: AND NOT EXISTS
2392: (SELECT 'x' FROM

Line 2415: PA_PJI_PROJ_EVENTS_LOG LOG,

2411: - 1,
2412: asg.project_id,
2413: -1
2414: FROM
2415: PA_PJI_PROJ_EVENTS_LOG LOG,
2416: PA_RBS_PRJ_ASSIGNMENTS asg
2417: WHERE
2418: log.EVENT_TYPE = 'RBS_PUSH' AND
2419: asg.RBS_VERSION_ID IN (log.EVENT_OBJECT, log.ATTRIBUTE2)

Line 2444: PA_PJI_PROJ_EVENTS_LOG LOG,

2440: - 1,
2441: asg.project_id,
2442: - 1
2443: FROM
2444: PA_PJI_PROJ_EVENTS_LOG LOG,
2445: PA_RBS_PRJ_ASSIGNMENTS asg
2446: WHERE
2447: log.EVENT_TYPE = 'RBS_DELETE' AND
2448: asg.RBS_VERSION_ID = log.EVENT_OBJECT