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 367: FROM DUAL

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

Line 381: FROM DUAL

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