DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_UC_DEFAULTS

Line 198: FROM igs_uc_defaults

194:
195: --Check whether the UCAS setup is defined or not for the Default prev_inst_left_date value.
196: CURSOR cur_ucas_setup ( cp_person_id igs_pe_person.person_id%TYPE ) IS
197: SELECT system_code
198: FROM igs_uc_defaults
199: WHERE prev_inst_left_date IS NULL
200: AND system_code IN ( SELECT DISTINCT app.system_code
201: FROM igs_uc_applicants app, igs_uc_app_stats stat
202: WHERE app.app_no = stat.app_no