890:
891:
892: -- Change to ALL_TAB_COLS for performance reasons when 9i db becomes prereq
893:
894: /* Added for bug 15889040. check against user_objects*/
895:
896: BEGIN
897: SELECT object_type into l_check_view_table
898: FROM USER_OBJECTS
894: /* Added for bug 15889040. check against user_objects*/
895:
896: BEGIN
897: SELECT object_type into l_check_view_table
898: FROM USER_OBJECTS
899: where OBJECT_NAME = p_source_type_view
900: and object_type = 'VIEW';
901:
902: /* p_source_type_view is a view then execute the below statement