APPS.CSF_TASKS_PUB dependencies on CSF_DEBRIEF_HEADERS

Line 118: FROM csf_debrief_headers cdh

114: FUNCTION is_debrief_closed(p_task_assignment_id NUMBER)
115: RETURN BOOLEAN IS
116: CURSOR c_debrief_status IS
117: SELECT NVL (cdh.processed_flag, 'PENDING') debrief_status
118: FROM csf_debrief_headers cdh
119: WHERE cdh.task_assignment_id = p_task_assignment_id;
120: BEGIN
121: FOR v_debrief_status IN c_debrief_status LOOP
122: IF v_debrief_status.debrief_status <> 'COMPLETED' THEN