eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1776: FROM ra_salesreps

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