APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on DUAL

Line 38: from dual

34: | Templates do not have scope. |
35: +---------------------------------------------------*/
36: BEGIN
37: select 'Y' into l_scope_exits
38: from dual
39: where exists ( select 1
40: from amw_execution_scope
41: where entity_type = 'PROJECT'
42: and entity_id = p_source_entity_id);

Line 315: select AMW_AUDIT_PROJECTS_S.nextval into l_audit_project_id FROM DUAL;

311:
312: BEGIN
313:
314:
315: select AMW_AUDIT_PROJECTS_S.nextval into l_audit_project_id FROM DUAL;
316:
317: select typ.work_type_id into l_engagement_type_id
318: from pa_projects_all ppa,
319: amw_work_types_b typ,

Line 350: FROM dual

346: SYSDATE,
347: FND_GLOBAL.USER_ID,
348: FND_GLOBAL.USER_ID,
349: 1
350: FROM dual
351: WHERE not exists (SELECT 'Y'
352: FROM AMW_AUDIT_PROJECTS
353: WHERE PROJECT_ID = p_project_id);
354:

Line 1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;

1038: BEGIN
1039:
1040: FOR ap_rec IN c_srceng_ap
1041: LOOP
1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1044: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1045: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1046: insert into AMW_AUDIT_PROCEDURES_B (

Line 1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;

1039:
1040: FOR ap_rec IN c_srceng_ap
1041: LOOP
1042: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1043: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1044: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1045: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1046: insert into AMW_AUDIT_PROCEDURES_B (
1047: PROJECT_ID,

Line 1118: FROM dual;

1114: SYSDATE,
1115: FND_GLOBAL.USER_ID,
1116: FND_GLOBAL.LOGIN_ID,
1117: ap_rec.CLASSIFICATION
1118: FROM dual;
1119:
1120: insert into AMW_AUDIT_PROCEDURES_TL (
1121: AUDIT_PROCEDURE_REV_ID,
1122: NAME,

Line 1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;

1426: BEGIN
1427:
1428: FOR ap_rec IN c_srceng_ap
1429: LOOP
1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1432: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1433: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1434: insert into AMW_AUDIT_PROCEDURES_B (

Line 1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;

1427:
1428: FOR ap_rec IN c_srceng_ap
1429: LOOP
1430: select amw_procedures_s.nextval into l_audit_procedure_id from dual;
1431: select amw_procedure_rev_s.nextval into l_audit_procedure_rev_id from dual;
1432: -- l_audit_procedure_id :=amw_procedures_s.nextval;
1433: -- l_audit_procedure_rev_id :=amw_procedure_rev_s.nextval;
1434: insert into AMW_AUDIT_PROCEDURES_B (
1435: PROJECT_ID,

Line 1506: FROM dual;

1502: SYSDATE,
1503: FND_GLOBAL.USER_ID,
1504: FND_GLOBAL.LOGIN_ID,
1505: ap_rec.CLASSIFICATION
1506: FROM dual;
1507:
1508: insert into AMW_AUDIT_PROCEDURES_TL (
1509: AUDIT_PROCEDURE_REV_ID,
1510: NAME,