APPS.OKC_ADOPTIONS_GRP dependencies on HR_ORGANIZATION_UNITS

Line 1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;

1189: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1190: l_prev_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
1191: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;
1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1194:
1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
1196: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 1217: HR_ORGANIZATION_UNITS U

1213:
1214: CURSOR l_org_info_csr (cp_org_id IN NUMBER, cp_global_org_id IN NUMBER) IS
1215: SELECT decode(nvl(ORG_INFORMATION1,'N'),'N','AVAILABLE','Y','ADOPTED') ADOPTION_TYPE, U.NAME
1216: FROM HR_ORGANIZATION_INFORMATION I,
1217: HR_ORGANIZATION_UNITS U
1218: WHERE I.ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1219: AND I.ORGANIZATION_ID = cp_org_id
1220: AND I.ORGANIZATION_ID = U.ORGANIZATION_ID
1221: AND I.ORGANIZATION_ID <> cp_global_org_id;