response VARCHAR2(4000);
  subject NUMBER;
  TYPE varray_type IS TABLE OF NUMBER(5,0);
  TYPE sarray_type IS TABLE OF VARCHAR2(4000);
  kinds varray_type;
  subjects varray_type;
  npas sarray_type;


 SELECT al.activity_kind_id
  BULK COLLECT INTO kinds
  FROM
    EISRSN.plan_doc_orders pdo
  join
    EISRSN.plan_arrangements pa ON pa.arrangement_id = pdo.arrangement_id
  join
    EISRSN.plan_arrangement_subjects pas ON pas.arrangement_id = pa.arrangement_id
  join
    EISRSN.app_licences al ON al.licence_id = pas.subject_id;

    SELECT bl.npl_content
    BULK COLLECT INTO npas
    FROM
      EISRSN.npls_catalog nc
    join
      EISRSN.npl_base_list bl ON bl.npl_base_id = nc.npl_id
    WHERE
      nc.sub_type_id IN COLLECT (kinds)
    ORDER BY 1 ASC;