APPS.OKL_ARINTF_PVT dependencies on RA_SALESREPS

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

2220:
2221:
2222: --vthiruva - Bug 4222231..start
2223: --modified sales_rep_csr to remove hard coded where clause
2224: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
2225: SELECT SALESREP_ID, SALESREP_NUMBER
2226: FROM ra_salesreps
2227: --WHERE NAME = 'No Sales Credit';
2228: WHERE SALESREP_ID = p_salesrep_id;

Line 2226: FROM ra_salesreps

2222: --vthiruva - Bug 4222231..start
2223: --modified sales_rep_csr to remove hard coded where clause
2224: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
2225: SELECT SALESREP_ID, SALESREP_NUMBER
2226: FROM ra_salesreps
2227: --WHERE NAME = 'No Sales Credit';
2228: WHERE SALESREP_ID = p_salesrep_id;
2229:
2230: --added new cursor to fetch the sales rep for the contract.

Line 2247: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

2243: SELECT sales_credit_type_id
2244: FROM so_sales_credit_types
2245: WHERE name = 'Quota Sales Credit';
2246:
2247: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2248: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2249: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2250:
2251: l_top_kle_id NUMBER;

Line 2248: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;

2244: FROM so_sales_credit_types
2245: WHERE name = 'Quota Sales Credit';
2246:
2247: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2248: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2249: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2250:
2251: l_top_kle_id NUMBER;
2252: