2105: SELECT 'Y'
2106: INTO l_loc_assignment_exist
2107: FROM DUAL
2108: WHERE EXISTS (SELECT 1
2109: FROM hz_loc_assignments la
2110: WHERE la.location_id = l_location_id
2111: );
2112: SELECT 'Y'
2113: INTO l_is_remit_to_location