APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 39: from csf_debrief_headers

35: is
36: select debrief_header_id
37: , task_assignment_id
38: , debrief_number
39: from csf_debrief_headers
40: where task_assignment_id = b_task_assignment_id;
41:
42: cursor c_task_obj_code
43: ( b_task_assignment_id number

Line 58: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE

54:
55: -- Cursor to check if the Assignment Status is either of the
56: -- following rejected, on_hold, cancelled, closed or completed
57: CURSOR c_chk_task_status
58: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
59: ) IS
60: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
61: tst.closed_flag, tst.completed_flag
62: FROM csf_debrief_headers dh, jtf_task_assignments tas,

Line 62: FROM csf_debrief_headers dh, jtf_task_assignments tas,

58: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
59: ) IS
60: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
61: tst.closed_flag, tst.completed_flag
62: FROM csf_debrief_headers dh, jtf_task_assignments tas,
63: jtf_task_statuses_b tst
64: WHERE dh.task_assignment_id = tas.task_assignment_id
65: AND tas.assignment_status_id = tst.task_status_id
66: AND dh.debrief_header_id = p_debrief_header_id;