DBA Data[Home] [Help]

APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_OBJECT_TYPES_VL

Line 102: ,fem_object_types_vl typ

98: from fem_wf_requests req
99: ,fem_wf_req_object_defs req_def
100: ,fem_object_definition_vl def
101: ,fem_object_catalog_vl obj
102: ,fem_object_types_vl typ
103: ,fem_folders_vl fol
104: where req.wf_request_id = p_request_id
105: and req.wf_request_item_code = p_request_item_code
106: and req.wf_request_type_code = p_request_type_code

Line 2191: ,fem_object_types_vl typ

2187: , f.folder_name
2188: , obj.object_name
2189: from fem_object_catalog_vl obj
2190: ,fem_folders_vl f
2191: ,fem_object_types_vl typ
2192: where upper(obj.object_name) = upper(p_obj_name)
2193: and obj.object_id <> nvl(p_obj_id,-1)
2194: and f.folder_id = obj.folder_id
2195: and typ.object_type_code = obj.object_type_code;