Total Pageviews

January 9, 2019

1/09/2019 10:56:00 AM
 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';

Next
This is the most recent post.
Older Post
 
Related Posts Plugin for WordPress, Blogger...