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 189: FROM JTF_TASKS_B task,

185: task.object_version_number,
186: --status.closed_flag,
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

Line 377: FROM JTF_TASKS_B tasks

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