APPS.CSM_DEBRIEF_PARTS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 98: FROM csf_debrief_headers dh, jtf_task_assignments tas,

94: CURSOR c_chk_task_status(p_debrief_header_id NUMBER)
95: IS
96: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
97: tst.closed_flag, tst.completed_flag
98: FROM csf_debrief_headers dh, jtf_task_assignments tas,
99: jtf_task_statuses_b tst
100: WHERE dh.task_assignment_id = tas.task_assignment_id
101: AND tas.assignment_status_id = tst.task_status_id
102: AND dh.debrief_header_id = p_debrief_header_id;

Line 130: , jtf_task_assignments jta

126: cursor c_task_obj_code ( b_task_assignment_id number)
127: is
128: select source_object_type_code
129: from jtf_tasks_b jtb
130: , jtf_task_assignments jta
131: where jtb.task_id = jta.task_id
132: and jta.task_assignment_id = b_task_assignment_id;
133:
134: r_deb_head c_deb_head%rowtype;