APPS.CE_VALIDATE_BANKINFO dependencies on HR_LOCATIONS

Line 405: FROM HR_LOCATIONS HR

401:
402: -- Companies
403: CURSOR CHECK_CROSS_HR IS
404: SELECT HR.GLOBAL_ATTRIBUTE8, HR.GLOBAL_ATTRIBUTE11
405: FROM HR_LOCATIONS HR
406: WHERE (HR.GLOBAL_ATTRIBUTE8= p_entity_name
407: OR HR.GLOBAL_ATTRIBUTE11= p_taxpayer_id)
408: AND substrb(nvl(HR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code
409: AND HR.LOCATION_USE = 'HR';