APPS.CSM_SR_EVENT_PKG dependencies on JTF_TASK_TYPES_B

Line 151: FROM jtf_tasks_b tsk, jtf_task_types_b ttype

147:
148: CURSOR l_jtf_tasks_csr(p_task_id jtf_tasks_b.task_id%TYPE)
149: IS
150: SELECT tsk.source_object_type_code
151: FROM jtf_tasks_b tsk, jtf_task_types_b ttype
152: WHERE tsk.task_id = p_task_id
153: AND tsk.task_type_id = ttype.task_type_id
154: AND (ttype.RULE = 'DISPATCH' OR ttype.private_flag = 'Y')
155: AND tsk.SCHEDULED_START_DATE IS NOT NULL

Line 843: JTF_TASK_TYPES_B ttype

839: SELECT inc.owner_group_id,
840: inc.created_by
841: FROM CS_INCIDENTS_ALL_B inc,
842: JTF_TASKS_B tsk,
843: JTF_TASK_TYPES_B ttype
844: WHERE tsk.TASK_ID=b_task_id
845: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
846: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
847: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 922: JTF_TASK_TYPES_B ttype

918: CURSOR c_tasks(b_incident_id NUMBER)
919: IS
920: SELECT TASK_ID
921: FROM JTF_TASKS_B tsk,
922: JTF_TASK_TYPES_B ttype
923: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
924: AND tsk.SOURCE_OBJECT_ID=b_incident_id
925: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID
926: AND ttype.RULE='DISPATCH';

Line 1161: JTF_TASK_TYPES_B ttype

1157: CURSOR c_tasks(b_incident_id NUMBER)
1158: IS
1159: SELECT tsk.TASK_ID
1160: FROM JTF_TASKS_B tsk,
1161: JTF_TASK_TYPES_B ttype
1162: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
1163: AND tsk.SOURCE_OBJECT_ID=b_incident_id
1164: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID
1165: AND ttype.RULE='DISPATCH';