APPS.IEU_TASKS_USERHOOKS dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 1518: FROM JTF_TASK_ALL_ASSIGNMENTS

1514: BEGIN
1515:
1516: SELECT booking_end_date
1517: INTO l_ins_due_date
1518: FROM JTF_TASK_ALL_ASSIGNMENTS
1519: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1520: AND assignee_role = 'OWNER';
1521:
1522: EXCEPTION

Line 2303: FROM JTF_TASK_ALL_ASSIGNMENTS

2299: BEGIN
2300:
2301: SELECT booking_end_date
2302: INTO l_ins_due_date
2303: FROM JTF_TASK_ALL_ASSIGNMENTS
2304: WHERE task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2305: AND assignee_role = 'OWNER';
2306:
2307: EXCEPTION

Line 2906: from jtf_task_all_assignments

2902:
2903: begin
2904: select task_id
2905: into l_task_id
2906: from jtf_task_all_assignments
2907: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
2908: exception when others then null;
2909: end;
2910:

Line 3035: FROM JTF_TASK_ALL_ASSIGNMENTS

3031: BEGIN
3032:
3033: SELECT booking_end_date
3034: INTO l_ins_due_date
3035: FROM JTF_TASK_ALL_ASSIGNMENTS
3036: WHERE task_id = (select task_id from jtf_task_all_assignments
3037: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)
3038: AND assignee_role = 'OWNER';
3039:

Line 3036: WHERE task_id = (select task_id from jtf_task_all_assignments

3032:
3033: SELECT booking_end_date
3034: INTO l_ins_due_date
3035: FROM JTF_TASK_ALL_ASSIGNMENTS
3036: WHERE task_id = (select task_id from jtf_task_all_assignments
3037: where task_assignment_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id)
3038: AND assignee_role = 'OWNER';
3039:
3040: EXCEPTION