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_EXTRACT_FIELDS_PKG dependencies on IGS_CA_INST_ALL

Line 848: igs_ca_inst_all cainstall

844: SELECT peresdtls.residency_status_cd residency_status
845: FROM igs_pe_res_dtls_all peresdtls,
846: igs_lookup_values cc1,
847: igs_lookup_values cc2,
848: igs_ca_inst_all cainstall
849: WHERE peresdtls.person_id = p_person_id
850: AND peresdtls.residency_class_cd = cc1.lookup_code
851: AND cc1.lookup_type = 'PE_RES_CLASS'
852: AND peresdtls.residency_status_cd = cc2.lookup_code

Line 1642: igs_ca_inst_all ca

1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca
1643: WHERE SPA.person_id = p_person_id and
1644: SPA.student_inst_number = p_student_inst_number AND
1645: SCA.person_id = SPA.person_id AND
1646: SCA.course_cd = SPA.course_cd AND

Line 3348: igs_ca_inst_all cainstall

3344: SELECT peresdtls.residency_status_cd residency_status
3345: FROM igs_pe_res_dtls_all peresdtls,
3346: igs_lookup_values cc1,
3347: igs_lookup_values cc2,
3348: igs_ca_inst_all cainstall
3349: WHERE peresdtls.person_id = p_person_id
3350: AND peresdtls.residency_class_cd = cc1.lookup_code
3351: AND cc1.lookup_type = 'PE_RES_CLASS'
3352: AND peresdtls.residency_status_cd = cc2.lookup_code