APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 594: FROM CSL_CSF_DEBRIEF_HEADERS_INQ inq

590: CURSOR c_chk_debrief_lines ( b_task_assignment_id NUMBER) IS
591: SELECT COUNT(*) FROM CSL_CSF_DEBRIEF_LINES_INQ
592: WHERE DEBRIEF_HEADER_ID IN (
593: SELECT DEBRIEF_HEADER_ID
594: FROM CSL_CSF_DEBRIEF_HEADERS_INQ inq
595: WHERE inq.TASK_ASSIGNMENT_ID = b_task_assignment_id
596: UNION
597: SELECT DEBRIEF_HEADER_ID
598: FROM CSF_DEBRIEF_HEADERS header

Line 598: FROM CSF_DEBRIEF_HEADERS header

594: FROM CSL_CSF_DEBRIEF_HEADERS_INQ inq
595: WHERE inq.TASK_ASSIGNMENT_ID = b_task_assignment_id
596: UNION
597: SELECT DEBRIEF_HEADER_ID
598: FROM CSF_DEBRIEF_HEADERS header
599: WHERE header.TASK_ASSIGNMENT_ID = b_task_assignment_id
600: ) ;
601:
602: -- ER 3218717

Line 608: FROM csf_debrief_headers dh, jtf_task_assignments tas,

604: ( b_task_assignment_id NUMBER
605: ) IS
606: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
607: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
608: FROM csf_debrief_headers dh, jtf_task_assignments tas,
609: jtf_task_statuses_b tst
610: WHERE dh.task_assignment_id = tas.task_assignment_id
611: AND tas.assignment_status_id = tst.task_status_id
612: AND tas.task_assignment_id = b_task_assignment_id;