APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on DUAL

Line 195: FROM DUAL

191: -- checking whether this location is for Remit-To Address or not
192: BEGIN
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);

Line 369: FROM DUAL

365: -- checking whether this location is for Remit-To Address or not
366: BEGIN
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);

Line 383: FROM DUAL

379: -- checking whether this location is already validated
380: BEGIN
381: SELECT 'Y'
382: INTO l_loc_assg_exists
383: FROM DUAL
384: WHERE EXISTS ( SELECT 1
385: FROM HZ_LOC_ASSIGNMENTS
386: WHERE LOCATION_ID = p_location_id);
387: EXCEPTION