[Home] [Help]
1297:
1298: BEGIN
1299: SELECT location_id
1300: INTO l_location_id
1301: FROM hr_locations
1302: WHERE location_id = p_cc_header_rec.location_id
1303: AND bill_to_site_flag = 'Y'
1304: AND NVL(inactive_date, sysdate+1) > sysdate;
1305: