APPS.AR_RAAPI_UTIL dependencies on RA_SALESREPS

Line 529: FROM ra_salesreps

525: /* END bug 3067675 */
526:
527: CURSOR c_salesrep_num (p_salesrep_number VARCHAR2) IS
528: SELECT salesrep_id
529: FROM ra_salesreps
530: WHERE salesrep_number = p_salesrep_number
531: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
532: AND NVL(end_date_active,SYSDATE)
533: AND g_trx_date BETWEEN NVL(start_date_active,g_trx_date)

Line 538: FROM ra_salesreps

534: AND NVL(end_date_active,g_trx_date) ;
535:
536: CURSOR c_salesrep_id (p_salesrep_id NUMBER) IS
537: SELECT salesrep_id
538: FROM ra_salesreps
539: WHERE salesrep_id = p_salesrep_id
540: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE)
541: AND NVL(end_date_active,SYSDATE)
542: AND g_trx_date BETWEEN NVL(start_date_active,g_trx_date)

Line 1777: FROM ra_salesreps

1773: IS
1774: l_cost_ctr VARCHAR2(30);
1775: CURSOR c_cost_ctr IS
1776: SELECT get_cost_ctr(gl_id_rev)
1777: FROM ra_salesreps
1778: WHERE salesrep_id = p_salesrep_id;
1779: BEGIN
1780: OPEN c_cost_ctr;
1781: FETCH c_cost_ctr INTO l_cost_ctr;

Line 2276: IF NOT arp_auto_accounting.query_autoacc_def('REV','RA_SALESREPS')

2272:
2273: l_line_acctd_amount := 0;
2274: l_cm_line_acctd_amount := 0;
2275: ELSE
2276: IF NOT arp_auto_accounting.query_autoacc_def('REV','RA_SALESREPS')
2277: THEN
2278: IF p_adjustment_type = 'SA'
2279: THEN
2280: /* can't use gl_dist data since it won't have