DBA Data[Home] [Help]

APPS.FEM_BUSINESS_RULE_PVT dependencies on FEM_FOLDERS_VL

Line 103: ,fem_folders_vl fol

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
107: and req_def.wf_request_id = req.wf_request_id

Line 132: ,fem_folders_vl fol

128: ,def.effective_start_date
129: ,def.effective_end_date
130: from fem_object_definition_vl def
131: ,fem_object_catalog_vl obj
132: ,fem_folders_vl fol
133: where def.object_id = obj.object_id
134: and fol.folder_id = obj.folder_id
135: and def.old_approved_copy_flag = G_CURRENT_COPY
136: and def.object_id = p_obj_id

Line 2190: ,fem_folders_vl f

2186: ,typ.object_type_name
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