APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_TASK_STATUSES_B

Line 6302: jtf_task_statuses_b b

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

Line 10017: , jtf_task_statuses_b stat

10013: , address_id -- Bug 8947959
10014: , location_id -- Bug 8947959
10015: FROM
10016: jtf_tasks_b task
10017: , jtf_task_statuses_b stat
10018: , jtf_task_types_b typ
10019: WHERE source_object_type_code = 'SR'
10020: AND source_object_id = p_incident_id
10021: AND stat.task_status_id = task.task_status_id