[Home] [Help]
115:
116: -- Cursor to fetch the current Institute Code
117: CURSOR crnt_inst_cur IS
118: SELECT DISTINCT current_inst_code
119: FROM igs_uc_defaults
120: WHERE current_inst_code IS NOT NULL;
121: l_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
122:
123: BEGIN
117: CURSOR crnt_inst_cur IS
118: SELECT DISTINCT current_inst_code
119: FROM igs_uc_defaults
120: WHERE current_inst_code IS NOT NULL;
121: l_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
122:
123: BEGIN
124:
125: IF (