APPS.OKC_ADOPTIONS_GRP dependencies on FND_LOOKUPS

Line 1192: l_adoption_type_meaning FND_LOOKUPS.MEANING%TYPE;

1188: l_return_status VARCHAR2(1);
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);

Line 1274: FROM FND_LOOKUPS

1270:
1271: CURSOR l_adoption_type_meaning_csr (
1272: cp_adoption_type IN VARCHAR2) IS
1273: SELECT meaning
1274: FROM FND_LOOKUPS
1275: WHERE lookup_type = 'OKC_ARTICLE_ADOPTION_TYPE'
1276: AND lookup_code = cp_adoption_type;
1277:
1278: