59: ) IS
60: SELECT oa.attribute_code
61: , oa.datatype
62: , oap.securable_flag
63: FROM oke_object_attributes_b oa
64: , oke_object_attributes_b oap
65: WHERE oa.database_object_name = C_Object_Name
66: AND oap.database_object_name = oa.database_object_name
67: AND oa.view_column_flag = 'Y'
60: SELECT oa.attribute_code
61: , oa.datatype
62: , oap.securable_flag
63: FROM oke_object_attributes_b oa
64: , oke_object_attributes_b oap
65: WHERE oa.database_object_name = C_Object_Name
66: AND oap.database_object_name = oa.database_object_name
67: AND oa.view_column_flag = 'Y'
68: AND oap.attribute_code = nvl( oa.parent_attribute_code