DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on RA_SALESREP_TERRITORIES

Line 3648: FROM ra_salesrep_territories st, ar_trx_header_gt gt

3644: l_trx_date DATE;
3645: l_salesrep_id NUMBER;
3646: CURSOR cSalesTer IS
3647: SELECT /*+ LEADING(gt) */ st.territory_id territory_id, gt.primary_salesrep_id
3648: FROM ra_salesrep_territories st, ar_trx_header_gt gt
3649: WHERE st.salesrep_id = gt.primary_salesrep_id
3650: AND 'A' = NVL(st.status(+), 'A')
3651: AND gt.trx_date BETWEEN NVL(st.start_date_active(+), gt.trx_date )
3652: AND NVL(st.end_date_active(+), gt.trx_date );