SELECT BASE_PAY INTO N FROM EMPLOYEES WHERE ID=p_ID;
SetPackageValueProc(PkgID,'YearlyBasePay',N);

SetPackageValueProc(PkgID,'YearlyBasePay',(SELECT BASE_PAY FROM EMPLOYEES WHERE ID=p_ID));

create or replace type ty_154_obj as object(col_1  number);
/

create or replace type ty_154 as table of ty_154_obj;
/

create table t_154 (col_1   number);

create table t_155 (col_1 number, col_2 varchar2(10));

insert into t_154 (select level from dual connect by level <=20);

insert into t_155 (select level,'Row '||level from dual connect by level <=20);

declare
  t_numbers   ty_154 := ty_154();
begin

  select ty_154_obj(col_1)
  bulk collect into t_numbers
  from   t_154
  where  mod(col_1,2)=0;
  
  for rec in (select t.col_2
              from   t_155 t
                    ,table(t_numbers) n
              where  t.col_1 = n.col_1) loop
    dbms_output.put_line(rec.col_2);
  end loop;
end;
/

SQL> declare
  2    t_numbers   ty_154 := ty_154();
  3  begin
  4  
  5    select ty_154_obj(col_1)
  6    bulk collect into t_numbers
  7    from   t_154
  8    where  mod(col_1,2)=0;
  9    
 10    for rec in (select t.col_2
 11                from   t_155 t
 12                      ,table(t_numbers) n
 13                where  t.col_1 = n.col_1) loop
 14      dbms_output.put_line(rec.col_2);
 15    end loop;
 16  end;
 17  /
Row 2
Row 4
Row 6
Row 8
Row 10
Row 12
Row 14
Row 16
Row 18
Row 20

PL/SQL procedure successfully completed.

CREATE OR REPLACE TYPE 
 numlist IS TABLE OF NUMBER;
/

CREATE OR REPLACE PROCEDURE listman (liste IN numlist)
AS
BEGIN
  FOR i IN liste.first .. liste.last LOOP
    dbms_output.put_line('i='||liste(i));
  END LOOP;
END;
/

SHOW ERRORS

SET SERVEROUTPUT ON SIZE 1000000;

EXEC listman(numlist(1,2,3,4));
/

i=1
i=2
i=3
i=4

DECLARE
  l1 numlist;
BEGIN
  SELECT LEVEL lv BULK COLLECT INTO l1 FROM dual CONNECT BY LEVEL<=4;
  listman(l1);
END;

i=1
i=2
i=3
i=4

SQL> var c refcursor
SQL> set timing on
SQL> begin open :c for select count(*) from dba_objects, dba_objects; end;
  2  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.14

SQL> print c
  COUNT(*)
----------
2367017104

1 row selected.

Elapsed: 00:02:54.81