DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1881: FROM hr_all_organization_units

1877: adoption_type_desc fnd_lookup_values.meaning%type;
1878:
1879: CURSOR org_name_csr(cp_org_id in number) IS
1880: SELECT name
1881: FROM hr_all_organization_units
1882: WHERE organization_id = cp_org_id;
1883:
1884: CURSOR adoption_type_meaning_csr(cp_adoption_type in VARCHAR2) IS
1885: SELECT meaning