DBA Data[Home] [Help]

APPS.CCT_LKUP_PUB dependencies on FND_GLOBAL

Line 49: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)

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
52: AND LV.LOOKUP_TYPE = 'CCT_BOOLEAN';
53:

Line 191: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)

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
194: AND LV.LOOKUP_TYPE = 'CCT_TRACE_LEVELS';
195:

Line 270: AND LV.SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)

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
273: AND LV.LOOKUP_TYPE = 'CCT_TEST_TYPES';
274: