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_PE_PERSON_BASE_V

Line 1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1309: AND a.institution_code = cp_inst_cd ;
1310: l_acad_hist_count NUMBER(3);
1311:
1312: -- Get the Person number for the passed person id.
1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1314: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
1315: FROM igs_pe_person_base_v
1316: WHERE person_id = cp_person_id;
1317: l_person_info_rec c_person_info%ROWTYPE;

Line 1315: FROM igs_pe_person_base_v

1311:
1312: -- Get the Person number for the passed person id.
1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1314: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
1315: FROM igs_pe_person_base_v
1316: WHERE person_id = cp_person_id;
1317: l_person_info_rec c_person_info%ROWTYPE;
1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table