APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_TASK_STATUSES_B

Line 6300: jtf_task_statuses_b b

6296: if ( l_sr_agent_security <> 'ANONE' ) then
6297: select count(*)
6298: into l_dummy
6299: from jtf_tasks_b a,
6300: jtf_task_statuses_b b
6301: where a.source_object_id = p_incident_id
6302: and a.source_object_type_code = 'SR'
6303: and a.task_status_id = b.task_status_id
6304: and b.closed_flag <> 'Y';

Line 9951: , jtf_task_statuses_b stat

9947: , task.object_version_number
9948: , DECODE(typ.rule, 'DISPATCH', 'Y', 'N') fs_task
9949: FROM
9950: jtf_tasks_b task
9951: , jtf_task_statuses_b stat
9952: , jtf_task_types_b typ
9953: WHERE source_object_type_code = 'SR'
9954: AND source_object_id = p_incident_id
9955: AND stat.task_status_id = task.task_status_id