/* Загрузка объектов в слайдер */
  PROCEDURE GET_SLIDER_OBJECTS(
      P_PARENT_ID IN VARCHAR2,
      OUT_CURSOR OUT SYS_REFCURSOR)
    AS
    BEGIN
      OPEN OUT_CURSOR FOR
        SELECT DISTINCT P.OBJECT_ID,
               P.VALUE,
               P2.VALUE,
               ITEMS.OBJECT_TYPE_ID
          FROM PARAMS P
               LEFT JOIN (
                 SELECT P.OBJECT_ID,
                        P.VALUE
                   FROM PARAMS P
                   WHERE P.ATTR_ID = 1428667837828
               ) P2  
                 ON P.OBJECT_ID = P2.OBJECT_ID, (
               SELECT O.OBJECT_TYPE_ID, 
                      O.OBJECT_ID
                 FROM OBJECTS O
                 WHERE O.PARENT_ID IS NULL
                   AND O.OBJECT_TYPE_ID IN (
                     SELECT OT.OBJECT_TYPE_ID
                       FROM OBJECT_TYPES OT
                       WHERE OT.PARENT_ID = TO_NUMBER(P_PARENT_ID)
                   )
               ) ITEMS
          WHERE P.OBJECT_ID = ITEMS.OBJECT_ID 
            AND P.ATTR_ID = 1428667839104; -- Аватар
    END GET_SLIDER_OBJECTS;