DBA Data[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_AUDIT_TASKS_V

Line 209: select task_id into v_task_id from amw_audit_tasks_v where task_name = taskid_rec.task_name

205: if taskid_rec.task_name = '-1' then
206: v_task_id := -1;
207:
208: else
209: select task_id into v_task_id from amw_audit_tasks_v where task_name = taskid_rec.task_name
210: and audit_project_id = taskid_rec.audit_project_id;
211: end if;
212:
213: update amw_audit_procedure_interface set task_id = v_task_id