TYPE v_cust_nmbr_tbl_type IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;

  CURSOR alt_csr (p_cust_nmbr_tbl v_cust_nmbr_tbl_type, p_curr_date VARCHAR2) IS
    SELECT LPAD(TO_CHAR(cust_nmbr),11)      ||
           RPAD(NVL(alt_id_type_cd,' '),8)  ||
           RPAD(alt_id,20)                  ||
           RPAD(NVL(alt_id_vldtn_cd,' '),1) ||
           RPAD(eff_dt,10)                  ||
           RPAD(end_dt,10)                  ||
           RPAD(NVL(apprvd_state_cd,' '),2) ||
           RPAD(last_updt_dt,10)            ||
           RPAD(last_updt_tm,8)             ||
           '     ' field
      FROM sales.cust_alt_id@gt_sales CAI
     WHERE cust_nmbr        IN
(
p_cust_nmbr_tbl(1),
p_cust_nmbr_tbl(2),
.
.<25 values in the list here>
.
p_cust_nmbr_tbl(25)
)
       AND end_dt           > p_curr_date
       AND RTRIM(alt_id)      IS NOT NULL
       AND alt_id_vldtn_cd IN ('0','a','q','y')
       AND (alt_id_type_cd IN ('MN','OT','UN')
            OR
            (alt_id_type_cd = 'MN'
             AND
             SUBSTR(alt_id,1,1) != 'A')
            OR
            (alt_id_type_cd = 'LCN'
             AND
             apprvd_state_cd != '  '));

p_cur_date is varchar2(10); and is initialised as

p_cur_date:=TO_CHAR(SYSDATE,'yyyy-mm-dd');