APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on AMW_PROCEDURE_REV_S

Line 557: SELECT amw_procedure_rev_s.nextval

553: l_dummy_audit_procedure_rec audit_procedure_rec_type;
554: l_row_id amw_audit_procedures_vl.row_id%TYPE;
555:
556: CURSOR c_rev_id IS
557: SELECT amw_procedure_rev_s.nextval
558: FROM dual;
559:
560: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
561: SELECT 1

Line 3608: SELECT amw_procedure_rev_s.nextval

3604: latest_revision_flag='Y';
3605: l_approval_status c_approval_status%ROWTYPE;
3606: l_dummy NUMBER;
3607: CURSOR c_get_rev_id IS
3608: SELECT amw_procedure_rev_s.nextval
3609: FROM dual;
3610: l_audit_procedure_rev_id NUMBER;
3611:
3612: BEGIN