APPS.FEM_TABLE_REGISTRATION_PKG dependencies on FND_LOOKUP_VALUES

Line 1860: FROM fnd_lookup_values

1856: l_classif VARCHAR2(100);
1857:
1858: CURSOR classifs(c_table_class_lookup_type VARCHAR2) IS
1859: SELECT lookup_code
1860: FROM fnd_lookup_values
1861: WHERE lookup_type=c_table_class_lookup_type
1862: AND language=userenv('LANG') ;
1863: BEGIN
1864: l_valid_flag := 'N';

Line 1881: FROM fnd_lookup_values

1877: l_concat_classif := LTRIM(l_concat_classif,',');
1878: SELECT DECODE(count(*),0,'N','Y') INTO l_valid_flag
1879: FROM fem_table_class_assignmt
1880: WHERE table_classification_code IN (SELECT lookup_code
1881: FROM fnd_lookup_values
1882: WHERE lookup_type=p_table_class_lookup_type
1883: AND language=userenv('LANG'))
1884: AND table_name = p_table_name
1885: AND enabled_flag='Y';