APPS.PJI_PJP_SUM_DENORM dependencies on DUAL

Line 332: from dual

328: ) event_object_id
329: from PJI_PA_PROJ_EVENTS_LOG i_log,
330: (
331: select 1 id
332: from dual
333: UNION ALL
334: select 2 id
335: from dual
336: ) invert

Line 335: from dual

331: select 1 id
332: from dual
333: UNION ALL
334: select 2 id
335: from dual
336: ) invert
337: where 1=1
338: and i_log.worker_id = P_WORKER_ID
339: and i_log.event_type in ('WBS_CHANGE', 'WBS_PUBLISH')

Line 375: from dual

371: ) event_object_id
372: from PJI_PA_PROJ_EVENTS_LOG i_log,
373: (
374: select 1 id
375: from dual
376: UNION ALL
377: select 2 id
378: from dual
379: ) invert

Line 378: from dual

374: select 1 id
375: from dual
376: UNION ALL
377: select 2 id
378: from dual
379: ) invert
380: where 1=1
381: and i_log.worker_id = P_WORKER_ID
382: and i_log.event_type = 'PRG_CHANGE'

Line 574: cursor c_version_exists is select 1 from dual

570:
571: -- -----------------------------------------------------
572: -- Declare statements --
573: /*bug#4590082, changed the WBS check to PRG slice check to see if any valid source version exists*/
574: cursor c_version_exists is select 1 from dual
575: where exists (select 1
576: from pa_xbs_denorm
577: where struct_version_id is null
578: and sup_id=p_wbs_version_id_from

Line 621: from dual

617: -- Checking if the target is already populated then not popultaing the denorm data
618: begin
619: select 1
620: into l_prg_exists
621: from dual
622: where exists (select 1
623: from pa_xbs_denorm
624: where struct_version_id is null
625: and sup_id=p_wbs_version_id_to

Line 1942: from dual

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')
1944: UNION ALL
1945: select 2 id
1946: from dual

Line 1946: from dual

1942: from dual
1943: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
1944: UNION ALL
1945: select 2 id
1946: from dual
1947: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
1948: ) invert
1949: where 1=1
1950: and i_log.worker_id = P_WORKER_ID

Line 1977: from dual

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')
1979: UNION ALL
1980: select 2 id
1981: from dual

Line 1981: from dual

1977: from dual
1978: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
1979: UNION ALL
1980: select 2 id
1981: from dual
1982: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
1983: ) invert
1984: where 1=1
1985: and i_log.worker_id = P_WORKER_ID