APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_APP_CLEARING

Line 82: CURSOR cur_app_clearing(cp_app_no igs_uc_app_clearing.app_no%TYPE) IS

78: AND ucas_cycle = cp_ucas_cycle;
79: l_clearing igs_uc_cyc_defaults.clearing_flag%TYPE;
80:
81: -- Check whether exists any clearing record for the applicant.
82: CURSOR cur_app_clearing(cp_app_no igs_uc_app_clearing.app_no%TYPE) IS
83: SELECT 'X'
84: FROM igs_uc_app_clearing
85: WHERE app_no = cp_app_no;
86:

Line 84: FROM igs_uc_app_clearing

80:
81: -- Check whether exists any clearing record for the applicant.
82: CURSOR cur_app_clearing(cp_app_no igs_uc_app_clearing.app_no%TYPE) IS
83: SELECT 'X'
84: FROM igs_uc_app_clearing
85: WHERE app_no = cp_app_no;
86:
87: app_clearing_rec cur_app_clearing%ROWTYPE;
88: