DBA Data[Home] [Help]

APPS.JTF_CAL_AVLBLTY_PVT dependencies on JTF_TASK_STATUSES_B

Line 52: , jtf_task_statuses_b jtsb

48: , jtb.calendar_end_date EndDate
49: , jtb.timezone_id TimezoneID
50: FROM jtf_task_all_assignments jta
51: , jtf_tasks_b jtb
52: , jtf_task_statuses_b jtsb
53: WHERE jta.resource_id = b_ResourceID -- 101272224
54: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
55: AND jta.task_id = jtb.task_id -- join to tasks_b
56: AND jtb.task_status_id = jtsb.task_status_id -- join to to task_status_b