DBA Data[Home] [Help]

APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on CSL_CSF_DEBRIEF_LINES_INQ

Line 591: SELECT COUNT(*) FROM CSL_CSF_DEBRIEF_LINES_INQ

587: -- ER 3218717
588: -- Check if there are any debrief line records in INQUEUE
589:
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