APPS.CE_VALIDATE_BANKINFO_UPG dependencies on HR_LOCATIONS

Line 314: FROM HR_LOCATIONS HR

310: AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;
311:
312: CURSOR CHECK_CROSS_HR IS --Companies
313: SELECT HR.GLOBAL_ATTRIBUTE8, HR.GLOBAL_ATTRIBUTE11
314: FROM HR_LOCATIONS HR
315: WHERE (HR.GLOBAL_ATTRIBUTE8= p_entity_name
316: OR HR.GLOBAL_ATTRIBUTE11= p_taxpayer_id)
317: AND substrb(nvl(HR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code
318: AND HR.LOCATION_USE = 'HR';