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_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_PS_APPL_ALL

Line 221: -- from the Admission Application,igs_ad_ps_appl_all

217: WHERE adm_outcome_status = p_adm_out_status;
218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind

Line 222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,

218: cur_s_adm_ou_stat_rec cur_s_adm_ou_stat%ROWTYPE;
219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all

Line 223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,

219:
220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id

Line 224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS

220: -- Cursor to find the the value of Reconsideration Flag
221: -- from the Admission Application,igs_ad_ps_appl_all
222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id
228: AND admission_appl_number = p_admission_appl_number

Line 226: FROM igs_ad_ps_appl_all

222: CURSOR cur_recons_flag ( p_person_id IGS_AD_PS_APPL_ALL.PERSON_ID%TYPE,
223: p_admission_appl_number IGS_AD_PS_APPL_ALL.ADMISSION_APPL_NUMBER%TYPE,
224: p_nominated_course_code IGS_AD_PS_APPL_ALL.NOMINATED_COURSE_CD%TYPE ) IS
225: SELECT req_for_reconsideration_ind
226: FROM igs_ad_ps_appl_all
227: WHERE person_id = p_person_id
228: AND admission_appl_number = p_admission_appl_number
229: AND nominated_course_cd = p_nominated_course_code;
230: cur_recons_flag_rec cur_recons_flag%ROWTYPE;