DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 510: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OU

506: -- get org name by org id
507: BEGIN
508: SELECT OU.NAME
509: INTO l_operation_unit
510: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ALL_ORGANIZATION_UNITS_TL OU
511: WHERE O.ORGANIZATION_ID = OU.ORGANIZATION_ID
512: AND OU.LANGUAGE = USERENV('LANG')
513: AND O.ORGANIZATION_ID = p_org_id;
514: