DBA Data[Home] [Help]

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 191: JTF_TASK_TYPES_B type

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