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.ARP_TRX_VALIDATE dependencies on RA_SALESREPS

Line 1820: FROM ra_salesreps

1816: BEGIN
1817:
1818: SELECT 'invoice date is ok'
1819: INTO l_temp
1820: FROM ra_salesreps
1821: WHERE salesrep_id = p_primary_salesrep_id
1822: AND p_trx_date BETWEEN NVL(start_date_active,
1823: p_trx_date)
1824: AND NVL(end_date_active,

Line 2085: ra_salesreps s

2081: INTO l_temp,
2082: l_temp2
2083: FROM ra_cust_trx_line_salesreps ls,
2084: ra_customer_trx_lines ctl,
2085: ra_salesreps s
2086: WHERE ls.salesrep_id = s.salesrep_id
2087: AND ls.customer_trx_id = p_customer_trx_id
2088: AND ls.customer_trx_line_id = ctl.customer_trx_line_id(+)
2089: AND p_trx_date NOT BETWEEN NVL(s.start_date_active,