APPS.IGS_EN_HESA_PKG dependencies on IGS_PE_PARTYSITEUSE_V

Line 152: FROM igs_pe_partysiteuse_v b

148: FROM igs_pe_addr_v a
149: WHERE a.person_id = p_person_id
150: AND (a.status = 'A' AND SYSDATE BETWEEN NVL(a.start_dt,SYSDATE) AND NVL(a.end_dt,SYSDATE))
151: AND (EXISTS(SELECT 'X'
152: FROM igs_pe_partysiteuse_v b
153: WHERE a.party_site_id = b.party_site_id
154: AND b.site_use_type = 'HOME'
155: AND b.active='Y')
156: OR a.correspondence = 'Y');