APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AP_ASSOCIATIONS

Line 227: where name = orgid_rec.organization_name and organization_id in (select pk2 from amw_ap_associations

223: FOR orgid_rec IN c_orgid LOOP
224: v_org_id := null;
225:
226: select organization_id into v_org_id from amw_audit_units_v
227: where name = orgid_rec.organization_name and organization_id in (select pk2 from amw_ap_associations
228: where pk1 = orgid_rec.audit_project_id and object_type = 'PROJECT' and pk4 = orgid_rec.task_id);
229:
230: update amw_audit_procedure_interface set organization_id = v_org_id
231: where organization_name = orgid_rec.organization_name and batch_id = p_batch_id

Line 243: and name = apid_rec.ap_name and audit_procedure_id in (select audit_procedure_id from amw_ap_associations

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
247: where ap_name = apid_rec.ap_name and batch_id = p_batch_id

Line 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

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);
264:
265:

Line 278: select distinct audit_procedure_rev_id into v_audit_procedure_rev_id from amw_AP_associations

274: -- To fetch audit_procedure_rev_id
275: fnd_file.put_line (fnd_file.LOG, 'To fetch rev id');
276: For aprevid_rec IN c_aprevid LOOP
277: v_audit_procedure_rev_id := null;
278: select distinct audit_procedure_rev_id into v_audit_procedure_rev_id from amw_AP_associations
279: where audit_procedure_id = aprevid_rec.audit_procedure_id and pk1 = aprevid_rec.audit_project_id
280: and pk2 = aprevid_rec.organization_id and pk4 = aprevid_rec.task_id
281: and object_type = 'PROJECT';
282: