APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_AUDIT_TASKS_TL

Line 185: INSERT INTO AMW_AUDIT_TASKS_TL(

181: where audit_project_id = p_source_entity_id;
182:
183: /* Insert data into the tl table */
184:
185: INSERT INTO AMW_AUDIT_TASKS_TL(
186: TASK_ID,
187: TASK_NAME,
188: DESCRIPTION,
189: LANGUAGE,

Line 210: amw_audit_tasks_tl stl,

206: FND_GLOBAL.USER_ID,
207: FND_GLOBAL.USER_ID,
208: 1
209: from amw_audit_tasks_b b,
210: amw_audit_tasks_tl stl,
211: amw_audit_tasks_b sb
212: where sb.audit_project_id = p_source_entity_id
213: and sb.task_id = stl.task_id
214: and b.task_number = sb.task_number

Line 923: DELETE FROM amw_audit_tasks_tl

919: FROM amw_audit_tasks_b
920: START WITH task_id = p_task_id
921: CONNECT BY PRIOR task_id = parent_task_id);
922:
923: DELETE FROM amw_audit_tasks_tl
924: WHERE task_id IN (SELECT task_id
925: FROM amw_audit_tasks_b
926: START WITH task_id = p_task_id
927: CONNECT BY PRIOR task_id = parent_task_id);