421:
422: -- Object that is being validated against
423: SELECT meaning
424: INTO v_obj_name
425: FROM fnd_lookup_values_vl
426: WHERE lookup_type = 'FEM_TAB_CLASS_OBJECTS'
427: AND lookup_code = p_prop_type;
428:
429: -- First, test for the case where a fixed column set is required.
2373: v_tab_class_cd VARCHAR2(30);
2374:
2375: CURSOR c_table_classes IS
2376: SELECT lookup_code
2377: FROM fnd_lookup_values_vl
2378: WHERE lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC';
2379:
2380:
2381: BEGIN
2505: */
2506:
2507: CURSOR c_table_classes IS
2508: SELECT lookup_code
2509: FROM fnd_lookup_values_vl flv
2510: WHERE flv.lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC'
2511: AND not exists(
2512: select ftcp.table_classification_code
2513: from fem_table_class_prop ftcp,