DBA Data[Home] [Help]

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: