APPS.JTF_CAL_PVT dependencies on JTF_TASK_STATUSES_B

Line 175: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */

171: ( b_ResourceID IN NUMBER
172: , b_ResourceType IN VARCHAR2
173: , b_StartDate IN DATE -- start of query period
174: , b_EndDate IN DATE -- end of query period
175: )IS SELECT /*+ INDEX(jtsb JTF_TASK_STATUSES_B_U1) */
176: jtb.task_id TaskId
177: , jtb.source_object_type_code SourceObjectTypeCode
178: , jtb.source_object_id SourceId
179: , jtb.customer_id CustomerId

Line 207: , jtf_task_statuses_b jtsb

203: , jta.object_version_number TaskOVN -- Needed to update todos
204: FROM jtf_task_all_assignments jta
205: , jtf_tasks_b jtb
206: , jtf_tasks_tl jtt
207: , jtf_task_statuses_b jtsb
208: WHERE jta.resource_id = b_ResourceID -- 101272224
209: AND jta.resource_type_code = b_ResourceType -- 'RS_EMPLOYEE'
210: AND jta.task_id = jtb.task_id -- join to tasks_b
211: AND jtb.task_status_id = jtsb.task_status_id -- join to to task_status_b