DBA Data[Home] [Help]

APPS.IGS_UC_APP_CHOICES_PKG dependencies on IGS_UC_DEFAULTS

Line 241: FROM igs_uc_defaults

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

Line 243: l_crnt_institute igs_uc_defaults.current_inst_code%TYPE;

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