eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_ACA dependencies on IGS_AD_PS_APPL_INST

Line 149: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

145: v_count_acai NUMBER;
146: CURSOR c_acai (
147: cp_person_id IGS_AD_APPL.person_id%TYPE,
148: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
149: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
150: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
151: SELECT COUNT(*)
152: FROM IGS_AD_PS_APPL_INST acai
153: WHERE acai.person_id = cp_person_id AND

Line 150: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS

146: CURSOR c_acai (
147: cp_person_id IGS_AD_APPL.person_id%TYPE,
148: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
149: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
150: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
151: SELECT COUNT(*)
152: FROM IGS_AD_PS_APPL_INST acai
153: WHERE acai.person_id = cp_person_id AND
154: acai.admission_appl_number = cp_admission_appl_number AND

Line 152: FROM IGS_AD_PS_APPL_INST acai

148: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
149: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
150: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
151: SELECT COUNT(*)
152: FROM IGS_AD_PS_APPL_INST acai
153: WHERE acai.person_id = cp_person_id AND
154: acai.admission_appl_number = cp_admission_appl_number AND
155: NOT (acai.nominated_course_cd = cp_nominated_course_cd AND
156: acai.sequence_number = cp_sequence_number);