130: select
131: a.object_name
132: ,b.folder_name
133: from
134: fem_object_catalog_vl a
135: ,fem_folders_vl b
136: where
137: a.object_id = p_Object_ID
138: and a.folder_id = b.folder_id;
135: ,fem_folders_vl b
136: where
137: a.object_id = p_Object_ID
138: and a.folder_id = b.folder_id;
139: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
140: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
141: Begin
142: OPEN getObjandFolderName;
143: FETCH getObjandFolderName into
157: a.object_name
158: ,b.folder_name
159: from
160: fem_object_definition_b c
161: ,fem_object_catalog_vl a
162: ,fem_folders_vl b
163: where
164: c.object_definition_id = p_Obj_Def_ID
165: and c.object_id = a.object_id
163: where
164: c.object_definition_id = p_Obj_Def_ID
165: and c.object_id = a.object_id
166: and a.folder_id = b.folder_id;
167: l_Object_Name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
168: l_Folder_Name FEM_FOLDERS_VL.FOLDER_NAME%TYPE;
169: Begin
170: OPEN getObjandFolderName;
171: FETCH getObjandFolderName into