Line 5888: l_salesrep_name ra_salesreps.name%type;
5884: p_org_id IN NUMBER)
5885:
5886: RETURN VARCHAR2 IS
5887: 5888: l_salesrep_name ra_salesreps.name%type; 5889:
5890: CURSOR get_salesrep_cur IS
5891: SELECT name
5892: FROM ra_salesreps
Line 5892: FROM ra_salesreps
5888: l_salesrep_name ra_salesreps.name%type;
5889:
5890: CURSOR get_salesrep_cur IS
5891: SELECT name 5892: FROM ra_salesreps 5893: WHERE salesrep_id = p_salesrep_id
5894: AND org_id = p_org_id;
5895:
5896: BEGIN