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 832: JTF_TASK_TYPES_B ttype

828: SELECT inc.owner_group_id,
829: inc.created_by
830: FROM CS_INCIDENTS_ALL_B inc,
831: JTF_TASKS_B tsk,
832: JTF_TASK_TYPES_B ttype
833: WHERE tsk.TASK_ID=b_task_id
834: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'
835: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID
836: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID

Line 906: JTF_TASK_TYPES_B ttype

902: CURSOR c_tasks(b_incident_id NUMBER)
903: IS
904: SELECT TASK_ID
905: FROM JTF_TASKS_B tsk,
906: JTF_TASK_TYPES_B ttype
907: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
908: AND tsk.SOURCE_OBJECT_ID=b_incident_id
909: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID
910: AND ttype.RULE='DISPATCH';

Line 1138: JTF_TASK_TYPES_B ttype

1134: CURSOR c_tasks(b_incident_id NUMBER)
1135: IS
1136: SELECT tsk.TASK_ID
1137: FROM JTF_TASKS_B tsk,
1138: JTF_TASK_TYPES_B ttype
1139: WHERE tsk.SOURCE_OBJECT_TYPE_CODE='SR'
1140: AND tsk.SOURCE_OBJECT_ID=b_incident_id
1141: AND ttype.TASK_TYPE_ID = tsk.TASK_TYPE_ID
1142: AND ttype.RULE='DISPATCH';