APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_APP_CLR_RND

Line 90: CURSOR cur_app_clr_rnd(cp_app_no igs_uc_app_clr_rnd.app_no%TYPE) IS

86:
87: app_clearing_rec cur_app_clearing%ROWTYPE;
88:
89: -- Check whether exists any clearing round details for the applicant.
90: CURSOR cur_app_clr_rnd(cp_app_no igs_uc_app_clr_rnd.app_no%TYPE) IS
91: SELECT 'X'
92: FROM igs_uc_app_clr_rnd
93: WHERE app_no = cp_app_no;
94:

Line 92: FROM igs_uc_app_clr_rnd

88:
89: -- Check whether exists any clearing round details for the applicant.
90: CURSOR cur_app_clr_rnd(cp_app_no igs_uc_app_clr_rnd.app_no%TYPE) IS
91: SELECT 'X'
92: FROM igs_uc_app_clr_rnd
93: WHERE app_no = cp_app_no;
94:
95: -- To Fetch the Decision Mapping to Admission Outcome Status for a UCAS System
96: CURSOR ucas_decision_cd_cur( p_system_code igs_uc_map_out_stat.system_code%TYPE,