APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AUDIT_PROCEDURES_VL

Line 242: select audit_procedure_id into v_audit_procedure_id from amw_audit_procedures_vl where curr_approved_flag = 'Y'

238: fnd_file.put_line (fnd_file.LOG, 'To fetch AP ID');
239: FOR apid_rec IN c_apid LOOP
240: v_audit_procedure_id := null;
241:
242: select audit_procedure_id into v_audit_procedure_id from amw_audit_procedures_vl where curr_approved_flag = 'Y'
243: and name = apid_rec.ap_name and audit_procedure_id in (select audit_procedure_id from amw_ap_associations
244: where object_type = 'PROJECT' and pk4 = apid_rec.task_id and pk1 = apid_rec.audit_project_id and pk2 = apid_rec.organization_id);
245:
246: update amw_audit_procedure_interface set audit_procedure_id = v_audit_procedure_id

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