APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_TASKS_B

Line 6301: from jtf_tasks_b a,

6297:
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

Line 6517: FROM jtf_tasks_b

6513:
6514: IF ( l_close_flag = 'Y' ) THEN
6515: SELECT COUNT(*)
6516: INTO l_dummy
6517: FROM jtf_tasks_b
6518: WHERE source_object_id = p_incident_id
6519: AND source_object_type_code = 'SR'
6520: AND NVL(open_flag,'Y') = 'Y'
6521: AND restrict_closure_flag = 'Y'

Line 10016: jtf_tasks_b task

10012: , DECODE(typ.rule, 'DISPATCH', 'Y', 'N') fs_task
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