APPS.IEU_TASKS_USERHOOKS dependencies on IEU_UWQM_PRIORITIES_B

Line 99: from ieu_uwqm_priorities_b

95:
96: begin
97: select priority_code
98: into l_priority_code
99: from ieu_uwqm_priorities_b
100: where priority_level = l_importance_level;
101: exception when others then null;
102: end;
103:

Line 109: from ieu_uwqm_priorities_b

105:
106: begin
107: select priority_code
108: into l_priority_code
109: from ieu_uwqm_priorities_b
110: where priority_level = 4;
111: exception when others then null;
112: end;
113:

Line 492: from ieu_uwqm_priorities_b

488:
489: begin
490: select priority_code, priority_id
491: into l_priority_code, l_priority_id
492: from ieu_uwqm_priorities_b
493: where priority_level = l_importance_level;
494: exception when others then null;
495: end;
496:

Line 502: from ieu_uwqm_priorities_b

498:
499: begin
500: select priority_code, priority_id
501: into l_priority_code, l_priority_id
502: from ieu_uwqm_priorities_b
503: where priority_level = 4;
504: exception when others then null;
505: end;
506:

Line 1669: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

1665: into l_ins_task_id, l_ins_task_number, l_ins_customer_id, l_ins_owner_id, l_ins_owner_type_code,
1666: l_ins_source_object_id, l_ins_source_object_type_code, l_ins_planned_start_date, l_ins_planned_end_date,
1667: l_ins_actual_ins_start_date, l_ins_actual_ins_end_date, l_ins_scheduled_start_date, l_ins_scheduled_end_date,
1668: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code
1669: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
1670: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1671: and tb.entity = 'TASK'
1672: and tb.task_id = tt.task_id
1673: and tt.language = userenv('LANG')

Line 2461: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

2457: l_ins_source_object_id, l_ins_source_object_type_code,
2458: l_ins_planned_start_date,
2459: l_ins_planned_end_date, l_ins_actual_ins_start_date, l_ins_actual_ins_end_date, l_ins_scheduled_start_date, l_ins_scheduled_end_date,
2460: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code
2461: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
2462: where tb.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2463: and tb.entity = 'TASK'
2464: and tb.task_id = tt.task_id
2465: and tt.language = userenv('LANG')

Line 3212: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

3208: into l_ins_task_id, l_ins_task_number, l_ins_customer_id, l_ins_owner_id, l_ins_owner_type_code,
3209: l_ins_source_object_id, l_ins_source_object_type_code,
3210: l_ins_planned_start_date, l_ins_planned_end_date, l_ins_actual_ins_start_date, l_ins_actual_ins_end_date, l_ins_scheduled_start_date, l_ins_scheduled_end_date,
3211: l_ins_task_type_id, l_ins_task_status_id, l_ins_task_name, l_ins_importance_level, l_ins_priority_code, l_entity
3212: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
3213: where tb.task_id = l_task_id
3214: and tb.entity = 'TASK'
3215: and tb.task_id = tt.task_id
3216: and tt.language = userenv('LANG')