APPS.IGS_AD_SS_GEN_001 dependencies on HZ_EDUCATION

Line 3816: FROM HZ_EDUCATION HE

3812:
3813: -- High School- SECONDARY
3814: CURSOR c_sec(cp_person_id igs_ad_appl.person_id%TYPE) IS
3815: SELECT 'x'
3816: FROM HZ_EDUCATION HE
3817: WHERE HE.PARTY_ID = cp_person_id
3818: AND HE.STATUS = 'A'
3819: AND EXISTS (SELECT 'X'
3820: FROM IGS_OR_ORG_INST_TYPE_ALL

Line 3833: FROM HZ_EDUCATION HE

3829:
3830: -- College/University- POST_SECONDARY
3831: CURSOR c_post_sec(cp_person_id igs_ad_appl.person_id%TYPE) IS
3832: SELECT 'x'
3833: FROM HZ_EDUCATION HE
3834: WHERE HE.PARTY_ID = cp_person_id
3835: AND HE.STATUS = 'A'
3836: AND EXISTS (SELECT 'X'
3837: FROM IGS_OR_ORG_INST_TYPE_ALL