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');
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');
1778: --