APPS.JMF_GTA_ARTRX_PROC dependencies on HR_ALL_ORGANIZATION_UNITS_TL
Line 482: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OU
478: -- get org name by org id
479: BEGIN
480: SELECT OU.NAME
481: INTO l_operation_unit 482: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OU 483: WHERE O.ORGANIZATION_ID = OU.ORGANIZATION_ID
484: AND OU.LANGUAGE = USERENV('LANG')
485: AND O.ORGANIZATION_ID = p_org_id;
486: