APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_ISIR_CORR_ALL

Line 410: FROM IGF_AP_ISIR_CORR_ALL ic

406:
407: -- Cursor to check wether the student has any outstanding corrections with status 'BATCHED'
408: CURSOR cur_corrections( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
409: SELECT 'X'
410: FROM IGF_AP_ISIR_CORR_ALL ic
411: WHERE ic.correction_status = 'BATCHED'
412: AND ic.isir_id IN ( SELECT im.isir_id
413: FROM IGF_AP_ISIR_MATCHED_ALL im
414: WHERE im.base_id = cp_base_id );