[Home] [Help]
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