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

Line 1295: CURSOR c_acad_hist ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,

1291: WHERE person_id = cp_person_id AND
1292: course_cd = cp_course_cd ;
1293:
1294: -- get the Academic history record for the student
1295: CURSOR c_acad_hist ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1296: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1297: SELECT a.*
1298: FROM igs_ad_acad_history_v a
1299: WHERE a.person_id = cp_person_id

Line 1296: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS

1292: course_cd = cp_course_cd ;
1293:
1294: -- get the Academic history record for the student
1295: CURSOR c_acad_hist ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1296: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1297: SELECT a.*
1298: FROM igs_ad_acad_history_v a
1299: WHERE a.person_id = cp_person_id
1300: AND a.institution_code = cp_inst_cd ;

Line 1298: FROM igs_ad_acad_history_v a

1294: -- get the Academic history record for the student
1295: CURSOR c_acad_hist ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1296: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1297: SELECT a.*
1298: FROM igs_ad_acad_history_v a
1299: WHERE a.person_id = cp_person_id
1300: AND a.institution_code = cp_inst_cd ;
1301: l_acad_hist_rec c_acad_hist%ROWTYPE ;
1302:

Line 1304: CURSOR c_acad_hist_count ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,

1300: AND a.institution_code = cp_inst_cd ;
1301: l_acad_hist_rec c_acad_hist%ROWTYPE ;
1302:
1303: -- get the Academic history record for the student
1304: CURSOR c_acad_hist_count ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1305: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1306: SELECT COUNT(*)
1307: FROM igs_ad_acad_history_v a
1308: WHERE a.person_id = cp_person_id

Line 1305: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS

1301: l_acad_hist_rec c_acad_hist%ROWTYPE ;
1302:
1303: -- get the Academic history record for the student
1304: CURSOR c_acad_hist_count ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1305: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1306: SELECT COUNT(*)
1307: FROM igs_ad_acad_history_v a
1308: WHERE a.person_id = cp_person_id
1309: AND a.institution_code = cp_inst_cd ;

Line 1307: FROM igs_ad_acad_history_v a

1303: -- get the Academic history record for the student
1304: CURSOR c_acad_hist_count ( cp_person_id igs_ad_acad_history_v.person_id%TYPE ,
1305: cp_inst_cd igs_ad_acad_history_v.institution_code%TYPE ) IS
1306: SELECT COUNT(*)
1307: FROM igs_ad_acad_history_v a
1308: WHERE a.person_id = cp_person_id
1309: AND a.institution_code = cp_inst_cd ;
1310: l_acad_hist_count NUMBER(3);
1311: