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
850: AND peresdtls.residency_class_cd = cc1.lookup_code
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
850: AND peresdtls.residency_class_cd = cc1.lookup_code
851: AND cc1.lookup_type = 'PE_RES_CLASS'
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
3350: AND peresdtls.residency_class_cd = cc1.lookup_code
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
3350: AND peresdtls.residency_class_cd = cc1.lookup_code
3351: AND cc1.lookup_type = 'PE_RES_CLASS'