Oracle EBS :Vendor Bill-to-location code validation

 SELECT lot.location_code
       INTO  l_bill_locn_code
       FROM   HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
       WHERE  loc.location_id = p_bill_location_id
       AND     sysdate < nvl(loc.inactive_date, sysdate + 1)
       AND     loc.location_id = lot.location_id
       AND     lot.language = userenv('LANG')
       AND     (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
                nvl(hr_general.get_business_group_id,-99))
       AND     loc.bill_to_site_flag = 'Y';