APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on HR_LOCATIONS
Line 1301: FROM hr_locations
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: