APPS.CS_SR_STATUS_PROPAGATION_PKG dependencies on JTF_TASKS_B

Line 51: FROM JTF_TASKS_B a,

47: a.scheduled_end_date,
48: a.actual_start_date,
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

Line 192: FROM JTF_TASKS_B task,

188: task.object_version_number,
189: --status.closed_flag,
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

Line 379: FROM JTF_TASKS_B tasks

375: AND order_line_id is null));
376:
377: CURSOR c_open_tasks IS
378: SELECT tasks.task_id
379: FROM JTF_TASKS_B tasks
380: --JTF_TASK_STATUSES_B status
381: WHERE tasks.source_object_type_code = 'SR'
382: AND tasks.source_object_id = p_service_request_id
383: --AND tasks.task_status_id = status.task_status_id