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
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