APPS.CSF_TASKS_PUB dependencies on CSF_DEBRIEF_HEADERS

Line 168: FROM csf_debrief_headers cdh

164: FUNCTION is_debrief_closed(p_task_assignment_id NUMBER)
165: RETURN BOOLEAN IS
166: CURSOR c_debrief_status IS
167: SELECT NVL (cdh.processed_flag, 'PENDING') debrief_status
168: FROM csf_debrief_headers cdh
169: WHERE cdh.task_assignment_id = p_task_assignment_id;
170: BEGIN
171: FOR v_debrief_status IN c_debrief_status LOOP
172: IF v_debrief_status.debrief_status <> 'COMPLETED' THEN