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

Line 462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci

458: CURSOR c_gap_res ( cp_person_id hz_parties.party_id%TYPE,
459: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
460: cp_start_dt DATE) IS
461: SELECT res.residency_status_cd, ci.start_dt
462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci
463: WHERE res.person_id = cp_person_id AND
464: res.residency_class_cd = cp_residency_class AND
465: res.start_dt <= cp_start_dt AND
466: res.CAL_TYPE = CI.CAL_TYPE AND