DBA Data[Home] [Help]

APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on CSL_CSF_DEBRIEF_HEADERS_INQ

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