DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1537: from hr_all_organization_units_tl xtl,

1533: where x.vacancy_id = p_vacancy_id ;
1534: --
1535: cursor get_organization is
1536: select xtl.name
1537: from hr_all_organization_units_tl xtl,
1538: hr_all_organization_units x
1539: where xtl.organization_id = p_org_id
1540: and x.organization_id = xtl.organization_id
1541: and xtl.LANGUAGE = userenv('LANG');