44: )
45: is
46: select source_object_type_code
47: from jtf_tasks_b jtb
48: , jtf_task_assignments jta
49: where jtb.task_id = jta.task_id
50: and jta.task_assignment_id = b_task_assignment_id;
51:
52: r_deb_head c_deb_head%rowtype;
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;