DBA Data[Home] [Help]

APPS.IEU_WR_PUB dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 2311: from jtf_task_all_assignments

2307:
2308: begin
2309: select booking_end_date
2310: into l_due_date
2311: from jtf_task_all_assignments
2312: where task_id = l_task_id
2313: and assignee_role = 'OWNER';
2314: exception when others then
2315: -- Work Source does not exist for this Object Code

Line 7186: from jtf_task_all_assignments

7182:
7183: begin
7184: select booking_end_date
7185: into l_due_date
7186: from jtf_task_all_assignments
7187: where task_id = l_task_id
7188: and assignee_role = 'OWNER';
7189: exception when others then
7190: -- Work Source does not exist for this Object Code

Line 11846: from jtf_task_all_assignments asg

11842:
11843: BEGIN
11844: update ieu_uwqm_items_gtt gtt
11845: set due_date = (select booking_end_date
11846: from jtf_task_all_assignments asg
11847: where asg.task_id = gtt.workitem_pk_id
11848: and asg.assignee_role= 'OWNER');
11849: EXCEPTION
11850: WHEN OTHERS THEN