7403: WHERE subject_id = p_subject;
7404:
7405:
7406: -- For data coming from Marvin INterface
7407: CURSOR c_map_exam_ebl(cp_exam_board_code IGS_UC_MAP_EBL_QUAL.exam_board_code%TYPE ,
7408: cp_ebl_code IGS_UC_MAP_EBL_QUAL.ebl_format%TYPE ) IS
7409: SELECT exam_level ,
7410: awarding_body,
7411: conv_ebl_format
7404:
7405:
7406: -- For data coming from Marvin INterface
7407: CURSOR c_map_exam_ebl(cp_exam_board_code IGS_UC_MAP_EBL_QUAL.exam_board_code%TYPE ,
7408: cp_ebl_code IGS_UC_MAP_EBL_QUAL.ebl_format%TYPE ) IS
7409: SELECT exam_level ,
7410: awarding_body,
7411: conv_ebl_format
7412: FROM igs_uc_map_ebl_qual
7408: cp_ebl_code IGS_UC_MAP_EBL_QUAL.ebl_format%TYPE ) IS
7409: SELECT exam_level ,
7410: awarding_body,
7411: conv_ebl_format
7412: FROM igs_uc_map_ebl_qual
7413: WHERE exam_board_code = cp_exam_board_code
7414: AND ebl_format = cp_ebl_code
7415: AND closed_ind = 'N' ;
7416: