APPS.AMW_PROCESS_CERT_SCOPE_PVT dependencies on DUAL

Line 78: FROM DUAL;

74: p_organization_id,
75: proc_rec.process_id,
76: p_top_process_id,
77: p_parent_process_id
78: FROM DUAL;
79: END LOOP;
80: END Insert_Process;
81:
82: PROCEDURE Insert_Audit_Units(

Line 159: FROM DUAL

155: null,
156: null,
157: null,
158: null
159: FROM DUAL
160: WHERE not exists (SELECT 'Y'
161: FROM AMW_EXECUTION_SCOPE
162: WHERE entity_type='PROCESS_CERTIFICATION'
163: AND entity_id= p_certification_id

Line 206: FROM DUAL

202: null,
203: null,
204: null,
205: null
206: FROM DUAL
207: WHERE not exists (SELECT 'Y'
208: FROM AMW_EXECUTION_SCOPE
209: WHERE entity_type='PROCESS_CERTIFICATION'
210: AND entity_id= p_certification_id

Line 255: FROM DUAL

251: audit_rec.organization_id,
252: null,
253: null,
254: null
255: FROM DUAL
256: WHERE not exists (SELECT 'Y'
257: FROM AMW_EXECUTION_SCOPE
258: WHERE entity_type='PROCESS_CERTIFICATION'
259: AND entity_id= p_certification_id

Line 307: FROM DUAL

303: org_process_rec.organization_id,
304: org_process_rec.top_process_id,
305: org_process_rec.top_process_id,
306: -1
307: FROM DUAL
308: WHERE not exists (SELECT 'Y'
309: FROM AMW_EXECUTION_SCOPE
310: WHERE entity_type='PROCESS_CERTIFICATION'
311: AND entity_id= p_certification_id

Line 457: FROM DUAL

453: null,
454: null,
455: null,
456: null
457: FROM DUAL
458: WHERE not exists (SELECT 'Y'
459: FROM AMW_EXECUTION_SCOPE
460: WHERE entity_type='PROCESS_CERTIFICATION'
461: AND entity_id= p_certification_id

Line 503: FROM DUAL

499: null,
500: null,
501: null,
502: null
503: FROM DUAL
504: WHERE not exists (SELECT 'Y'
505: FROM AMW_EXECUTION_SCOPE
506: WHERE entity_type='PROCESS_CERTIFICATION'
507: AND entity_id= p_certification_id

Line 551: FROM DUAL

547: audit_rec.organization_id,
548: null,
549: null,
550: null
551: FROM DUAL
552: WHERE not exists (SELECT 'Y'
553: FROM AMW_EXECUTION_SCOPE
554: WHERE entity_type='PROCESS_CERTIFICATION'
555: AND entity_id= p_certification_id

Line 628: FROM DUAL

624: l_organization_id,
625: l_process_id,
626: l_process_id,
627: -1
628: FROM DUAL
629: WHERE not exists (SELECT 'Y'
630: FROM AMW_EXECUTION_SCOPE
631: WHERE entity_type='PROCESS_CERTIFICATION'
632: AND entity_id= p_certification_id