APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_SALESREPS

Line 952: l_new_salesrep_name ra_salesreps.name%TYPE;

948: l_debit_sales_credit_id NUMBER;
949: l_credit_sales_credit_id NUMBER;
950: l_total_sc_percent NUMBER;
951: l_neg_sc_limit NUMBER;
952: l_new_salesrep_name ra_salesreps.name%TYPE;
953: l_max_percent NUMBER;
954:
955: l_warehouse_id NUMBER; -- Bug 1930302.
956: l_gl_date_valid DATE; -- Bug 2146970

Line 1204: FROM ra_salesreps

1200: GROUP BY s.salesrep_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', s.non_revenue_salesgroup_id,s.revenue_salesgroup_id);
1201:
1202: CURSOR c_new_salesrep_name IS
1203: SELECT name
1204: FROM ra_salesreps
1205: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
1206:
1207: BEGIN
1208: IF PG_DEBUG in ('Y', 'C') THEN

Line 2053: l_new_salesrep_name ra_salesreps.name%TYPE;

2049: l_cust_trx_line_id NUMBER;
2050: l_line_number NUMBER;
2051: l_total_sc_percent NUMBER;
2052: l_neg_sc_limit NUMBER;
2053: l_new_salesrep_name ra_salesreps.name%TYPE;
2054:
2055: invalid_sc_total EXCEPTION;
2056: invalid_amount EXCEPTION;
2057:

Line 2131: FROM ra_salesreps

2127: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id;
2128:
2129: CURSOR c_new_salesrep_name IS
2130: SELECT name
2131: FROM ra_salesreps
2132: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
2133:
2134: BEGIN
2135:

Line 2933: FROM ra_salesreps

2929: ORDER BY gl_date ASC;
2930:
2931: CURSOR c_salesrep_count IS
2932: SELECT COUNT(*)
2933: FROM ra_salesreps
2934: WHERE salesrep_id IN
2935: (SELECT salesrep_id
2936: FROM ra_cust_trx_line_salesreps
2937: WHERE customer_trx_line_id = p_customer_trx_line_id

Line 3357: FROM ra_salesreps

3353: invalid_other EXCEPTION;
3354:
3355: CURSOR c_salesrep_count IS
3356: SELECT COUNT(*)
3357: FROM ra_salesreps
3358: WHERE salesrep_id IN
3359: (SELECT salesrep_id
3360: FROM ra_cust_trx_line_salesreps
3361: WHERE customer_trx_line_id = p_customer_trx_line_id

Line 4753: FROM ra_salesreps

4749: invalid_ccid EXCEPTION;
4750:
4751: CURSOR c_salesrep_count IS
4752: SELECT COUNT(*)
4753: FROM ra_salesreps
4754: WHERE salesrep_id IN
4755: (SELECT salesrep_id
4756: FROM ra_cust_trx_line_salesreps
4757: WHERE customer_trx_line_id = p_customer_trx_line_id