147: p_lookup_code IN VARCHAR2)
148: RETURN VARCHAR2;
149:
150: TYPE srep_rec_type IS RECORD
151: (salesrep_name ra_salesreps.name%TYPE,
152: salesrep_number ra_salesreps.salesrep_number%TYPE);
153:
154: TYPE t_salesrep_table IS TABLE OF srep_rec_type
155: INDEX BY BINARY_INTEGER;
148: RETURN VARCHAR2;
149:
150: TYPE srep_rec_type IS RECORD
151: (salesrep_name ra_salesreps.name%TYPE,
152: salesrep_number ra_salesreps.salesrep_number%TYPE);
153:
154: TYPE t_salesrep_table IS TABLE OF srep_rec_type
155: INDEX BY BINARY_INTEGER;
156: