DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on RA_SALESREP_TERRITORIES

Line 3553: FROM ra_salesrep_territories st, ar_trx_header_gt gt

3549: l_trx_date DATE;
3550: l_salesrep_id NUMBER;
3551: CURSOR cSalesTer IS
3552: SELECT /*+ LEADING(gt) */ st.territory_id territory_id, gt.primary_salesrep_id
3553: FROM ra_salesrep_territories st, ar_trx_header_gt gt
3554: WHERE st.salesrep_id = gt.primary_salesrep_id
3555: AND 'A' = NVL(st.status(+), 'A')
3556: AND gt.trx_date BETWEEN NVL(st.start_date_active(+), gt.trx_date )
3557: AND NVL(st.end_date_active(+), gt.trx_date );