DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_RES_DTLS_ALL

Line 845: FROM igs_pe_res_dtls_all peresdtls,

841: -- anwest modified this cursor for HE356 to get open and closed values and not restricted to OSS_RESIDENCY_OS
842: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view
843: CURSOR c_res_sts (cp_res_class_cd VARCHAR2) IS
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

Line 3345: FROM igs_pe_res_dtls_all peresdtls,

3341: -- anwest modified this cursor for HE356 to accommodate Term/Load Calendar for Residency Status
3342: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_res_dtls_v view
3343: CURSOR c_res_sts (cp_res_class_cd VARCHAR2) IS
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