APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on RA_SALESREPS
Line 1053: l_salesperson ra_salesreps.name%type;
1049: FUNCTION get_salesperson (
1050: p_salesrep_id NUMBER,
1051: p_org_id NUMBER) RETURN VARCHAR2 IS
1052: 1053: l_salesperson ra_salesreps.name%type; 1054:
1055: CURSOR get_salesrep_cur IS
1056: SELECT name
1057: FROM ra_salesreps
Line 1057: FROM ra_salesreps
1053: l_salesperson ra_salesreps.name%type;
1054:
1055: CURSOR get_salesrep_cur IS
1056: SELECT name 1057: FROM ra_salesreps 1058: WHERE salesrep_id = p_salesrep_id
1059: AND org_id = p_org_id;
1060:
1061: BEGIN