DBA Data[Home] [Help]

APPS.CCT_LKUP_PUB dependencies on FND_LOOKUP_VALUES

Line 47: SELECT lv.MEANING, lv.lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

43: l_lov_code := IEO_STRING_VARR();
44:
45: -- API body
46:
47: SELECT lv.MEANING, lv.lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
48: WHERE LV.VIEW_APPLICATION_ID = 0
49: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
50: AND LV.ENABLED_FLAG='Y'
51: AND LV.LANGUAGE = p_env_lang

Line 189: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

185: l_lov_code := IEO_STRING_VARR();
186:
187: -- API body
188:
189: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
190: WHERE LV.VIEW_APPLICATION_ID = 0
191: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
192: AND LV.ENABLED_FLAG='Y'
193: AND LV.LANGUAGE = p_env_lang

Line 268: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

264: l_lov_code := IEO_STRING_VARR();
265:
266: -- API body
267:
268: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV
269: WHERE LV.VIEW_APPLICATION_ID = 0
270: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
271: AND LV.ENABLED_FLAG='Y'
272: AND LV.LANGUAGE = p_env_lang