APPS.BSC_DIM_LEVEL_FILTERS_PUB dependencies on USER_OBJECTS

Line 664: FROM user_objects

660:
661:
662: l_cnt := 0;
663: SELECT COUNT(0) INTO l_cnt
664: FROM user_objects
665: WHERE object_name = l_view;
666:
667:
668: IF (l_cnt <> 0) THEN

Line 745: FROM user_objects

741: RETURN NULL;
742: END IF;
743:
744: SELECT COUNT(DISTINCT object_name) INTO l_view_count
745: FROM user_objects
746: WHERE object_name like p_dimension_table || '_V%';
747:
748:
749: l_view_count := l_view_count+1;

Line 755: FROM user_objects

751:
752:
753: WHILE TRUE LOOP
754: SELECT COUNT(0) INTO l_v_count
755: FROM user_objects
756: WHERE object_name = l_result;
757:
758: EXIT WHEN l_v_count = 0;
759: