1666: ,f.folder_name
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
1726: Begin
1727: select count(required_object_id)
1728: into
1729: l_Dependent_Object_Count
1730: from fem_object_Dependencies
1731: where object_definition_id = p_Parent_Obj_Def_Id;
1732:
1733: If (l_Dependent_Object_Count = 0) then
1734: If (p_Valid_Dep_Obj_Status = 'NA') then