APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_HZ_PARTIES

Line 1095: igs_pe_hz_parties php

1091: othinst.new_institution
1092: FROM igs_ss_ad_othins_stg othinst,
1093: igs_ss_adm_appl_stg appl,
1094: igs_or_institution i,
1095: igs_pe_hz_parties php
1096: WHERE othinst.ss_adm_appl_id = appl.ss_adm_appl_id
1097: AND othinst.institution_code = i.institution_cd
1098: AND othinst.institution_code = php.oss_org_unit_cd
1099: AND appl.person_id = p_person_id

Line 3696: FROM IGS_PE_HZ_PARTIES

3692:
3693: -- Felony- FELONY
3694: CURSOR c_felony(cp_person_id igs_ad_appl.person_id%TYPE) IS
3695: SELECT FELONY_CONVICTED_FLAG
3696: FROM IGS_PE_HZ_PARTIES
3697: WHERE PARTY_ID = cp_person_id;
3698:
3699: -- Housing Status- HOUSING_STATUS
3700: CURSOR c_housing(cp_person_id igs_ad_appl.person_id%TYPE) IS

Line 3823: FROM IGS_PE_HZ_PARTIES

3819: AND EXISTS (SELECT 'X'
3820: FROM IGS_OR_ORG_INST_TYPE_ALL
3821: WHERE INSTITUTION_TYPE = DECODE (HE.SCHOOL_PARTY_ID, NULL, NULL,
3822: (SELECT OI_INSTITUTION_TYPE
3823: FROM IGS_PE_HZ_PARTIES
3824: WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
3825: AND INST_ORG_IND = 'I'
3826: )
3827: )

Line 3839: FROM IGS_PE_HZ_PARTIES

3835: AND HE.STATUS = 'A'
3836: AND EXISTS (SELECT 'X'
3837: FROM IGS_OR_ORG_INST_TYPE_ALL
3838: WHERE INSTITUTION_TYPE = DECODE (HE.SCHOOL_PARTY_ID, NULL, NULL, (SELECT OI_INSTITUTION_TYPE
3839: FROM IGS_PE_HZ_PARTIES
3840: WHERE HE.SCHOOL_PARTY_ID = PARTY_ID
3841: AND INST_ORG_IND = 'I') )
3842: AND SYSTEM_INST_TYPE IN ('POST-SECONDARY', 'OTHER')
3843: );