36: )
37: is
38: select debrief_header_id
39: , task_assignment_id
40: from csf_debrief_headers
41: where task_assignment_id = b_task_assignment_id;
42:
43: cursor c_task_obj_code
44: ( b_task_assignment_id number
55:
56: -- Cursor to check if the Assignment Status is either of the
57: -- following rejected, on_hold, cancelled, closed or completed
58: CURSOR c_chk_task_status
59: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
60: ) IS
61: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
62: tst.closed_flag, tst.completed_flag
63: FROM csf_debrief_headers dh, jtf_task_assignments tas,
59: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
60: ) IS
61: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
62: tst.closed_flag, tst.completed_flag
63: FROM csf_debrief_headers dh, jtf_task_assignments tas,
64: jtf_task_statuses_b tst
65: WHERE dh.task_assignment_id = tas.task_assignment_id
66: AND tas.assignment_status_id = tst.task_status_id
67: AND dh.debrief_header_id = p_debrief_header_id;