DBA Data[Home] [Help]

APPS.FEM_RULE_SET_MANAGER dependencies on FEM_FOLDERS_VL

Line 460: ,fem_folders_vl f

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:
464: Begin

Line 1672: ,fem_folders_vl f

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
1676: and o.folder_id = f.folder_id

Line 2089: ,FEM_FOLDERS_VL cm_f

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
2092: and rsm_d.OBJECT_ID = p_Curr_RuleSet_Object_ID
2093: and rsm.RULE_SET_OBJ_DEF_ID = rs.RULE_SET_OBJ_DEF_ID