APPS.CE_VALIDATE_BANKINFO dependencies on HR_LOCATIONS

Line 428: FROM HR_LOCATIONS HR

424: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
425:
426: CURSOR CHECK_CROSS_HR IS --Companies
427: SELECT HR.GLOBAL_ATTRIBUTE8, HR.GLOBAL_ATTRIBUTE11
428: FROM HR_LOCATIONS HR
429: WHERE (HR.GLOBAL_ATTRIBUTE8= p_entity_name
430: OR HR.GLOBAL_ATTRIBUTE11= p_taxpayer_id)
431: AND substrb(nvl(HR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code
432: AND HR.LOCATION_USE = 'HR';