[Home] [Help]
49:
50:
51: CURSOR c_salesrep_id IS
52: SELECT salesrep_id
53: FROM jtf_rs_salesreps
54: WHERE salesrep_id = l_salesrep_id;
55: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;
56:
57:
206: l_org_id number;
207:
208: CURSOR c_salesrep_id IS
209: SELECT salesrep_id
210: FROM jtf_rs_salesreps
211: WHERE salesrep_id = l_salesrep_id;
212: l_salesrep jtf_rs_srp_territories.salesrep_id%type ;
213:
214: BEGIN