APPS.FEM_RULE_SET_MANAGER dependencies on FEM_OBJECT_CATALOG_VL

Line 177: from fem_object_catalog_vl o

173: l_module_name VARCHAR2(70) := G_MODULE_NAME || 'GetObjectDisplayName';
174:
175: Cursor getObjectDisplayName(p_Obj_ID IN DEF_OBJECT_ID%TYPE) IS
176: select o.object_name
177: from fem_object_catalog_vl o
178: where o.object_id = p_Obj_ID;
179:
180: Begin
181: -- *******************************************************************************************

Line 459: from fem_object_catalog_vl o

455:
456: Cursor getNameAndFolder(p_Obj_ID IN DEF_OBJECT_ID%TYPE) IS
457: select o.object_name
458: ,f.folder_name
459: from fem_object_catalog_vl o
460: ,fem_folders_vl f
461: where o.object_id = p_Obj_ID
462: and f.folder_id = o.folder_id;
463:

Line 1671: ,fem_object_catalog_vl o

1667: ,o.object_type_code
1668: ,t.OBJECT_TYPE_NAME
1669: from
1670: fem_object_dependencies a
1671: ,fem_object_catalog_vl o
1672: ,fem_folders_vl f
1673: ,fem_object_types t
1674: where a.object_definition_id = p_Parent_Obj_Def_Id
1675: and a.required_object_id = o.object_id

Line 2087: ,FEM_OBJECT_CATALOG_VL cm_o

2083: ,nvl(cm_o.LOCAL_VS_COMBO_ID,-1) as Child_Local_VS_Combo_ID
2084: from
2085: FEM_RULE_SET_MEMBERS rsm
2086: ,FEM_RULE_SETS rs
2087: ,FEM_OBJECT_CATALOG_VL cm_o
2088: ,FEM_OBJECT_DEFINITION_B rsm_d
2089: ,FEM_FOLDERS_VL cm_f
2090: where
2091: rsm.RULE_SET_OBJ_DEF_ID = rsm_d.OBJECT_DEFINITION_ID