APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_U_CVNAME_2003

Line 90: SELECT COUNT(*) FROM igs_uc_u_cvname_2003

86: AND ucas_cycle = p_ucas_cycle
87: AND transaction_type = 'RD';
88:
89: CURSOR cur_find_appclear IS
90: SELECT COUNT(*) FROM igs_uc_u_cvname_2003
91: WHERE appno = P_App_no;
92:
93: CURSOR cur_find_appclear_2006 IS
94: SELECT COUNT(*) FROM igs_uc_u_cvname_2003

Line 94: SELECT COUNT(*) FROM igs_uc_u_cvname_2003

90: SELECT COUNT(*) FROM igs_uc_u_cvname_2003
91: WHERE appno = P_App_no;
92:
93: CURSOR cur_find_appclear_2006 IS
94: SELECT COUNT(*) FROM igs_uc_u_cvname_2003
95: WHERE appno =
96: (SELECT LPAD((app_no||check_digit),9,0) from IGS_UC_APPLICANTS where app_no = P_App_no);
97:
98: -- Check whether there exists any applicant record for generating PE