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