DBA Data[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AUDIT_UNITS_V

Line 226: select organization_id into v_org_id from amw_audit_units_v

222: fnd_file.put_line (fnd_file.LOG, 'To fetch org id');
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