APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on HR_LOCATIONS

Line 3047: FROM hr_locations

3043: P_X_Error_Status);
3044: ELSIF P_Vendor_Id IS NOT NULL AND P_Location_Id IS NOT NULL THEN
3045: BEGIN
3046: SELECT location_id INTO l_location_id
3047: FROM hr_locations
3048: WHERE location_id = P_location_Id
3049: AND bill_to_site_flag = 'Y'
3050: AND NVL(inactive_date, sysdate+1) > sysdate;
3051: EXCEPTION WHEN NO_DATA_FOUND THEN