APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AP_STEPS_VL

Line 294: select ap_step_id into v_step_id from amw_ap_steps_vl aasv, amw_audit_procedures_vl ap

290: -- To fetch step Id
291: fnd_file.put_line (fnd_file.LOG, 'To fetch Step Id');
292: FOR stepid_rec IN c_stepid LOOP
293: v_step_id := null;
294: select ap_step_id into v_step_id from amw_ap_steps_vl aasv, amw_audit_procedures_vl ap
295: where aasv.name = stepid_rec.step_name and aasv.cseqnum = stepid_rec.step_number
296: and aasv.audit_procedure_id = stepid_rec.audit_procedure_id
297: and ap.audit_procedure_rev_id = stepid_rec.audit_procedure_rev_id
298: and ap.audit_procedure_id = stepid_rec.audit_procedure_id