APPS.IBE_ADDRESS_V2PVT dependencies on HZ_PARTY_SITES_V

Line 1553: hz_party_sites_v

1549: party_site_id, location_id
1550: INTO
1551: x_party_site_id, x_location_id
1552: FROM
1553: hz_party_sites_v
1554: WHERE
1555: party_id = p_party_id AND
1556: site_use_type = p_site_use_type AND
1557: status = 'A' AND

Line 1737: FROM hz_party_sites_v

1733: INTO l_party_site_number
1734: FROM dual;
1735:
1736: SELECT COUNT(*) INTO l_count
1737: FROM hz_party_sites_v
1738: WHERE party_site_number = l_party_site_number;
1739:
1740: END LOOP;
1741: