APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on HZ_PARTY_SITES

Line 197: FROM HZ_PARTY_SITES PS

193: SELECT 'Y'
194: INTO l_is_remit_to_location
195: FROM DUAL
196: WHERE EXISTS ( SELECT 1
197: FROM HZ_PARTY_SITES PS
198: WHERE PS.LOCATION_ID = p_location_id
199: AND PS.PARTY_ID = -1);
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN

Line 369: FROM HZ_PARTY_SITES PS

365: SELECT 'Y'
366: INTO l_is_remit_to_location
367: FROM DUAL
368: WHERE EXISTS ( SELECT 1
369: FROM HZ_PARTY_SITES PS
370: WHERE PS.LOCATION_ID = p_location_id
371: AND PS.PARTY_ID = -1);
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN