DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_MAP_EBL_QUAL

Line 7407: CURSOR c_map_exam_ebl(cp_exam_board_code IGS_UC_MAP_EBL_QUAL.exam_board_code%TYPE ,

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

Line 7408: cp_ebl_code IGS_UC_MAP_EBL_QUAL.ebl_format%TYPE ) IS

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

Line 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: