APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on JTF_TASK_TYPES_B

Line 53: JTF_TASK_TYPES_B c

49: a.actual_end_date,
50: c.rule
51: FROM JTF_TASKS_B a,
52: --JTF_TASK_STATUSES_B b,
53: JTF_TASK_TYPES_B c
54: WHERE a.task_type_id = c.task_type_id
55: --a.task_status_id = b.task_status_id
56: AND a.source_object_type_code = 'SR'
57: AND a.source_object_id = p_service_request_id;

Line 194: JTF_TASK_TYPES_B type

190: task.open_flag,
191: type.rule
192: FROM JTF_TASKS_B task,
193: --JTF_TASK_STATUSES_B status,
194: JTF_TASK_TYPES_B type
195: WHERE task.source_object_type_code = 'SR'
196: AND task.source_object_id = p_service_request_id
197: AND task.task_type_id = type.task_type_id
198: --AND task.task_status_id = status.task_status_id