APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_TASKS_B

Line 6299: from jtf_tasks_b a,

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

Line 6501: FROM jtf_tasks_b

6497:
6498: IF ( l_close_flag = 'Y' ) THEN
6499: SELECT COUNT(*)
6500: INTO l_dummy
6501: FROM jtf_tasks_b
6502: WHERE source_object_id = p_incident_id
6503: AND source_object_type_code = 'SR'
6504: AND NVL(open_flag,'Y') = 'Y'
6505: AND restrict_closure_flag = 'Y'

Line 9950: jtf_tasks_b task

9946: task.task_id
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