[Home] [Help]
237:
238: -- Cursor to fetch the current Institute Code
239: CURSOR crnt_inst_cur IS
240: SELECT DISTINCT current_inst_code
241: FROM igs_uc_defaults
242: WHERE current_inst_code IS NOT NULL;
243: l_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
244:
245: BEGIN
239: CURSOR crnt_inst_cur IS
240: SELECT DISTINCT current_inst_code
241: FROM igs_uc_defaults
242: WHERE current_inst_code IS NOT NULL;
243: l_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
244:
245: BEGIN
246:
247: IF (((old_references.app_id = new_references.app_id)) OR