APPS.ARP_TRX_VALIDATE dependencies on RA_SALESREPS

Line 1823: FROM ra_salesreps

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

Line 2088: ra_salesreps s

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