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 371: FROM HZ_PARTY_SITES PS

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