APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on HZ_PARTY_SITES

Line 1771: hz_party_sites b,

1767: -- jtmathew modified this cursor for bug 5210481 to remove igs_pe_addr_v view
1768: CURSOR c_addrus IS
1769: SELECT MAX( site_use_type)
1770: FROM igs_pe_partysiteuse_v a,
1771: hz_party_sites b,
1772: igs_pe_hz_pty_sites c,
1773: igs_he_code_values d
1774: WHERE a.party_site_id = b.party_site_id
1775: AND b.party_site_id = c.party_site_id(+)