DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1773: from hr_all_organization_units_tl xtl,

1769: where x.vacancy_id = p_vacancy_id ;
1770: --
1771: cursor get_organization is
1772: select xtl.name
1773: from hr_all_organization_units_tl xtl,
1774: hr_all_organization_units x
1775: where xtl.organization_id = p_org_id
1776: and x.organization_id = xtl.organization_id
1777: and xtl.LANGUAGE = userenv('LANG');