APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on RA_SALESREPS

Line 1029: l_new_salesrep_name ra_salesreps.name%TYPE;

1025: l_debit_sales_credit_id NUMBER;
1026: l_credit_sales_credit_id NUMBER;
1027: l_total_sc_percent NUMBER;
1028: l_neg_sc_limit NUMBER;
1029: l_new_salesrep_name ra_salesreps.name%TYPE;
1030: l_max_percent NUMBER;
1031:
1032: l_warehouse_id NUMBER; -- Bug 1930302.
1033: l_gl_date_valid DATE; -- Bug 2146970

Line 1281: FROM ra_salesreps

1277: GROUP BY s.salesrep_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', s.non_revenue_salesgroup_id,s.revenue_salesgroup_id);
1278:
1279: CURSOR c_new_salesrep_name IS
1280: SELECT name
1281: FROM ra_salesreps
1282: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
1283:
1284: BEGIN
1285: IF PG_DEBUG in ('Y', 'C') THEN

Line 2130: l_new_salesrep_name ra_salesreps.name%TYPE;

2126: l_cust_trx_line_id NUMBER;
2127: l_line_number NUMBER;
2128: l_total_sc_percent NUMBER;
2129: l_neg_sc_limit NUMBER;
2130: l_new_salesrep_name ra_salesreps.name%TYPE;
2131:
2132: invalid_sc_total EXCEPTION;
2133: invalid_amount EXCEPTION;
2134:

Line 2208: FROM ra_salesreps

2204: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id;
2205:
2206: CURSOR c_new_salesrep_name IS
2207: SELECT name
2208: FROM ra_salesreps
2209: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
2210:
2211: BEGIN
2212:

Line 3118: FROM ra_salesreps

3114: ORDER BY gl_date ASC;
3115:
3116: CURSOR c_salesrep_count IS
3117: SELECT COUNT(*)
3118: FROM ra_salesreps
3119: WHERE salesrep_id IN
3120: (SELECT salesrep_id
3121: FROM ra_cust_trx_line_salesreps
3122: WHERE customer_trx_line_id = p_customer_trx_line_id

Line 3550: FROM ra_salesreps

3546: invalid_other EXCEPTION;
3547:
3548: CURSOR c_salesrep_count IS
3549: SELECT COUNT(*)
3550: FROM ra_salesreps
3551: WHERE salesrep_id IN
3552: (SELECT salesrep_id
3553: FROM ra_cust_trx_line_salesreps
3554: WHERE customer_trx_line_id = p_customer_trx_line_id

Line 4978: FROM ra_salesreps

4974: invalid_ccid EXCEPTION;
4975:
4976: CURSOR c_salesrep_count IS
4977: SELECT COUNT(*)
4978: FROM ra_salesreps
4979: WHERE salesrep_id IN
4980: (SELECT salesrep_id
4981: FROM ra_cust_trx_line_salesreps
4982: WHERE customer_trx_line_id = p_customer_trx_line_id