APPS.OKL_ARINTF_PVT dependencies on RA_SALESREPS

Line 1258: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS

1254:
1255:
1256: --vthiruva - Bug 4222231..start
1257: --modified sales_rep_csr to remove hard coded where clause
1258: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
1259: SELECT SALESREP_ID, SALESREP_NUMBER
1260: FROM ra_salesreps
1261: --WHERE NAME = 'No Sales Credit';
1262: WHERE SALESREP_ID = p_salesrep_id;

Line 1260: FROM ra_salesreps

1256: --vthiruva - Bug 4222231..start
1257: --modified sales_rep_csr to remove hard coded where clause
1258: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
1259: SELECT SALESREP_ID, SALESREP_NUMBER
1260: FROM ra_salesreps
1261: --WHERE NAME = 'No Sales Credit';
1262: WHERE SALESREP_ID = p_salesrep_id;
1263:
1264: --added new cursor to fetch the sales rep for the contract.

Line 1281: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

1277: SELECT sales_credit_type_id
1278: FROM so_sales_credit_types
1279: WHERE name = 'Quota Sales Credit';
1280:
1281: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
1282: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
1283: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
1284:
1285: l_kle_id NUMBER;

Line 1282: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;

1278: FROM so_sales_credit_types
1279: WHERE name = 'Quota Sales Credit';
1280:
1281: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
1282: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
1283: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
1284:
1285: l_kle_id NUMBER;
1286: l_top_kle_id NUMBER;