DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on JTF_TASK_STATUSES_B

Line 207: jtf_task_statuses_b jts

203: CURSOR l_jtf_task_status_csr(p_task_id jtf_tasks_b.task_id%TYPE)
204: IS
205: SELECT 1
206: FROM jtf_tasks_b jt,
207: jtf_task_statuses_b jts
208: WHERE jt.task_id = p_task_id
209: AND jt.task_status_id = jts.task_status_id
210: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL
211: OR (jts.assigned_flag = 'Y'

Line 257: jtf_task_statuses_b jts

253: IS
254: SELECT 1
255: FROM jtf_task_assignments jta,
256: jtf_tasks_b jt,
257: jtf_task_statuses_b jts
258: WHERE jta.task_assignment_id = p_task_assg_id
259: AND jt.task_id = jta.task_id
260: AND jta.assignment_status_id = jts.task_status_id
261: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL