DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1832: FROM hr_all_organization_units

1828: adoption_type_desc fnd_lookup_values.meaning%type;
1829:
1830: CURSOR org_name_csr(cp_org_id in number) IS
1831: SELECT name
1832: FROM hr_all_organization_units
1833: WHERE organization_id = cp_org_id;
1834:
1835: CURSOR adoption_type_meaning_csr(cp_adoption_type in VARCHAR2) IS
1836: SELECT meaning