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 2002: from dual

1998: ) event_object_id
1999: from PJI_PA_PROJ_EVENTS_LOG i_log,
2000: (
2001: select 1 id
2002: from dual
2003: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2004: UNION ALL
2005: select 2 id
2006: from dual

Line 2006: from dual

2002: from dual
2003: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2004: UNION ALL
2005: select 2 id
2006: from dual
2007: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2008: ) invert
2009: where 1=1
2010: and i_log.worker_id = P_WORKER_ID

Line 2037: from dual

2033: ) event_object_id
2034: from PJI_PA_PROJ_EVENTS_LOG i_log,
2035: (
2036: select 1 id
2037: from dual
2038: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2039: UNION ALL
2040: select 2 id
2041: from dual

Line 2041: from dual

2037: from dual
2038: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2039: UNION ALL
2040: select 2 id
2041: from dual
2042: where p_extraction_type IN ('INCREMENTAL', 'PARTIAL')
2043: ) invert
2044: where 1=1
2045: and i_log.worker_id = P_WORKER_ID

Line 2716: select 1 into l_wbs_node_count from dual

2712: -- then we know that the node is a leaf
2713:
2714: -- Bug 12731239 starts
2715: BEGIN
2716: select 1 into l_wbs_node_count from dual
2717: where exists (select 1 from PJI_FP_AGGR_XBS wdt_count
2718: where wdt_count.sup_id = WBS_NODE.element_version_id
2719: and wdt_count.worker_id = P_WORKER_ID);
2720: EXCEPTION