11672: SELECT 'Y'
11673: INTO l_loc_assignment_exist
11674: FROM DUAL
11675: WHERE EXISTS (SELECT 1
11676: FROM hz_loc_assignments la
11677: WHERE la.location_id = l_location_id
11678: );
11679: SELECT 'Y'
11680: INTO l_is_remit_to_location