APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_PARTYSITEUSE_V

Line 3592: FROM IGS_PE_ADDR_V addr, IGS_PE_PARTYSITEUSE_V use

3588:
3589: -- Address - ADDRESS
3590: CURSOR c_addr(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS
3591: SELECT 'x'
3592: FROM IGS_PE_ADDR_V addr, IGS_PE_PARTYSITEUSE_V use
3593: WHERE addr.PERSON_ID = cp_person_id
3594: AND addr.STATUS = 'A'
3595: AND addr.party_site_id = use.party_site_id
3596: AND use.site_use_type IN