[Home] [Help]
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