DBA Data[Home] [Help]

APPS.JTF_TASKS_PVT dependencies on JTF_TASK_STATUSES_B

Line 3341: FROM jtf_task_statuses_b

3337:
3338: /* moved from pub package*/
3339: CURSOR c_owner_status_id(b_owner_status_id jtf_task_all_assignments.assignment_status_id%TYPE) IS
3340: SELECT task_status_id
3341: FROM jtf_task_statuses_b
3342: WHERE task_status_id = b_owner_status_id
3343: --AND assigned_flag = 'Y'
3344: AND assignment_status_flag = 'Y' -- Fix bug 2500664
3345: AND NVL(end_date_active, SYSDATE) >= SYSDATE

Line 6022: , jtf_task_statuses_b jtsb

6018: FROM jtf_tasks_vl jta
6019: , jtf_task_types_tl jttt
6020: , jtf_task_types_b jttb
6021: , jtf_task_statuses_tl jtst
6022: , jtf_task_statuses_b jtsb
6023: , jtf_task_priorities_tl jtpt
6024: , jtf_objects_tl jtot
6025: , jtf_objects_b jtob
6026: , jtf_objects_tl jto2