APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_CONTROLS_TL

Line 259: select control_id into v_ctrl_id from amw_controls_b acb, amw_controls_tl act

255: fnd_file.put_line (fnd_file.LOG, 'To fetch Ctrl Id');
256: FOR ctrlid_rec IN c_ctrlid LOOP
257: v_ctrl_id := null;
258:
259: select control_id into v_ctrl_id from amw_controls_b acb, amw_controls_tl act
260: where act.language(+)= userenv('LANG') and act.name = ctrlid_rec.control_name and act.description = ctrlid_rec.control_description
261: and act.control_rev_id = acb.control_rev_id and acb.curr_approved_flag = 'Y' and acb.control_id in (select pk3 from amw_ap_associations
262: where object_type = 'PROJECT' and pk1 = ctrlid_rec.audit_project_id and pk2 = ctrlid_rec.organization_id and
263: pk4 = ctrlid_rec.task_id and audit_procedure_id = ctrlid_rec.audit_procedure_id);