APPS.HZ_TAX_ASSIGNMENT_PUB dependencies on HZ_PARTY_SITES
Line 205: FROM hz_party_sites ps
201: SELECT 'Y'
202: INTO l_is_remit_to_location
203: FROM DUAL
204: WHERE EXISTS ( SELECT 1 205: FROM hz_party_sites ps 206: WHERE ps.location_id = p_location_id
207: AND ps.party_id = -1);
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN