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_APPL

Line 147: cp_person_id IGS_AD_APPL.person_id%TYPE,

143: DECLARE
144: cst_course CONSTANT VARCHAR2(6) := 'COURSE';
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(*)

Line 148: cp_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

144: cst_course CONSTANT VARCHAR2(6) := 'COURSE';
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