APPS.AR_INVOICE_UTILS dependencies on RA_SALESREPS

Line 2197: FROM ra_salesreps rs

2193: FROM ar_trx_header_gt gt
2194: WHERE gt.primary_salesrep_id IS NOT NULL
2195: AND NOT EXISTS (
2196: (SELECT 'X'
2197: FROM ra_salesreps rs
2198: WHERE rs.salesrep_id = gt.primary_salesrep_id
2199: AND gt.trx_date
2200: BETWEEN rs.start_date_active
2201: AND NVL(rs.end_date_active, gt.trx_date)));

Line 7657: FROM RA_SALESREPS REP

7653: FROM ar_trx_salescredits_gt SC
7654: WHERE salesrep_id IS NOT NULL
7655: AND NOT EXISTS
7656: (SELECT 'X'
7657: FROM RA_SALESREPS REP
7658: WHERE REP.SALESREP_ID = SC.SALESREP_ID);
7659:
7660: l_message_name := gl_public_sector.get_message_name (
7661: p_message_name => 'AR_INAPI_NVALID_SALESREP_NUM',

Line 7680: FROM RA_SALESREPS REP

7676: FROM ar_trx_salescredits_gt SC
7677: WHERE sc.salesrep_num IS NOT NULL
7678: AND NOT EXISTS
7679: (SELECT 'X'
7680: FROM RA_SALESREPS REP
7681: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7682:
7683: UPDATE ar_trx_salescredits_gt SC
7684: SET SALESREP_ID = (SELECT SALESREP_ID

Line 7685: FROM RA_SALESREPS REP

7681: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7682:
7683: UPDATE ar_trx_salescredits_gt SC
7684: SET SALESREP_ID = (SELECT SALESREP_ID
7685: FROM RA_SALESREPS REP
7686: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7687: WHERE salesrep_id IS NULL;
7688:
7689: l_message_name := gl_public_sector.get_message_name (