APPS.AR_INVOICE_UTILS dependencies on RA_SALESREPS

Line 2120: FROM ra_salesreps rs

2116: FROM ar_trx_header_gt gt
2117: WHERE gt.primary_salesrep_id IS NOT NULL
2118: AND NOT EXISTS (
2119: (SELECT 'X'
2120: FROM ra_salesreps rs
2121: WHERE rs.salesrep_id = gt.primary_salesrep_id
2122: AND gt.trx_date
2123: BETWEEN rs.start_date_active
2124: AND NVL(rs.end_date_active, sysdate)));

Line 7318: FROM RA_SALESREPS REP

7314: FROM ar_trx_salescredits_gt SC
7315: WHERE salesrep_id IS NOT NULL
7316: AND NOT EXISTS
7317: (SELECT 'X'
7318: FROM RA_SALESREPS REP
7319: WHERE REP.SALESREP_ID = SC.SALESREP_ID);
7320:
7321: l_message_name := gl_public_sector.get_message_name (
7322: p_message_name => 'AR_INAPI_NVALID_SALESREP_NUM',

Line 7341: FROM RA_SALESREPS REP

7337: FROM ar_trx_salescredits_gt SC
7338: WHERE sc.salesrep_num IS NOT NULL
7339: AND NOT EXISTS
7340: (SELECT 'X'
7341: FROM RA_SALESREPS REP
7342: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7343:
7344: UPDATE ar_trx_salescredits_gt SC
7345: SET SALESREP_ID = (SELECT SALESREP_ID

Line 7346: FROM RA_SALESREPS REP

7342: WHERE REP.SALESREP_NUMber = SC.SALESREP_NUM);
7343:
7344: UPDATE ar_trx_salescredits_gt SC
7345: SET SALESREP_ID = (SELECT SALESREP_ID
7346: FROM RA_SALESREPS REP
7347: WHERE REP.SALESREP_NUMBER = SC.SALESREP_NUM)
7348: WHERE salesrep_id IS NULL;
7349:
7350: l_message_name := gl_public_sector.get_message_name (