APPS.AMW_LOAD_AP_DATA dependencies on AMW_AUDIT_PROCEDURES_TL

Line 171: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl

167: AND rownum = 1;
168:
169: CURSOR c_ap_exists (c_ap_name IN VARCHAR2) IS
170: SELECT b.audit_procedure_id, b.approval_status
171: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl
172: WHERE tl.name = c_ap_name
173: AND tl.language = USERENV('LANG')
174: AND tl.audit_procedure_rev_id = b.audit_procedure_rev_id
175: AND b.latest_revision_flag='Y';

Line 349: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl

345: lx_audit_procedure_id := null; ---setting this to NULL to avoid conflict with value from previous loop
346: begin
347: SELECT b.audit_procedure_id
348: into lx_audit_procedure_id
349: FROM amw_audit_procedures_b b, amw_audit_procedures_tl tl
350: WHERE tl.name = ap_rec.ap_name
351: AND tl.language = USERENV('LANG')
352: AND tl.audit_procedure_rev_id = b.audit_procedure_rev_id
353: AND b.latest_revision_flag='Y';