DBA Data[Home] [Help]

APPS.IEU_TASKS_USERHOOKS dependencies on JTF_TASK_PRIORITIES_VL

Line 77: from jtf_task_priorities_vl

73: *****************************************************************************/
74: begin
75: select importance_level
76: into l_importance_level
77: from jtf_task_priorities_vl
78: where task_priority_id = jtf_tasks_pub.p_task_user_hooks.task_priority_id;
79: exception when others then null;
80: end;
81:

Line 482: from jtf_task_priorities_vl

478:
479: begin
480: select importance_level
481: into l_importance_level
482: from jtf_task_priorities_vl
483: where task_priority_id = jtf_tasks_pub.p_task_user_hooks.task_priority_id;
484: exception when others then null;
485: end;
486:

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')