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_EXP_APPLICANT_DTLS dependencies on IGS_AD_ACAD_HISTORY_V

Line 2188: CURSOR cur_get_hist_details ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,

2184: AND map1 = cp_map1;
2185:
2186: -- get the Academic history record for the student
2187: -- jchin - bug 4950293
2188: CURSOR cur_get_hist_details ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
2189: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
2190: SELECT 'X'
2191: FROM igs_ad_acad_history_v a
2192: WHERE a.person_id = cp_person_id

Line 2189: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS

2185:
2186: -- get the Academic history record for the student
2187: -- jchin - bug 4950293
2188: CURSOR cur_get_hist_details ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
2189: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
2190: SELECT 'X'
2191: FROM igs_ad_acad_history_v a
2192: WHERE a.person_id = cp_person_id
2193: AND a.institution_code = cp_inst_cd ;

Line 2191: FROM igs_ad_acad_history_v a

2187: -- jchin - bug 4950293
2188: CURSOR cur_get_hist_details ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
2189: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
2190: SELECT 'X'
2191: FROM igs_ad_acad_history_v a
2192: WHERE a.person_id = cp_person_id
2193: AND a.institution_code = cp_inst_cd ;
2194:
2195: l_oss_inst igs_he_code_map_val.map2%TYPE;