APPS.AR_IREC_PAYMENTS dependencies on RA_TERMS

Line 2329: RA_TERMS trm

2325: ( decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) ) dispute_amt
2326: FROM AR_PAYMENT_SCHEDULES ps,
2327: RA_CUSTOMER_TRX ct,
2328: HZ_CUST_ACCOUNTS acct,
2329: RA_TERMS trm
2330: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')
2331: AND ps.customer_trx_id = ct.customer_trx_id
2332: AND acct.cust_account_id = ps.customer_id
2333: AND ps.status = 'OP'

Line 2623: RA_TERMS trm

2619: 0 dispute_amt
2620: FROM AR_PAYMENT_SCHEDULES ps,
2621: RA_CUSTOMER_TRX_ALL ct,
2622: HZ_CUST_ACCOUNTS acct,
2623: RA_TERMS trm
2624: WHERE ps.customer_id = p_customer_id
2625: AND ( ps.CLASS = 'CM'
2626: OR
2627: ps.CLASS = 'PMT'

Line 5817: RA_TERMS trm

5813: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5814: FROM AR_PAYMENT_SCHEDULES ps,
5815: RA_CUSTOMER_TRX_ALL ct,
5816: HZ_CUST_ACCOUNTS acct,
5817: RA_TERMS trm
5818: WHERE ps.payment_schedule_id = p_payment_schedule_id
5819: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar
5820: AND ps.customer_trx_id = ct.customer_trx_id(+)
5821: AND acct.cust_account_id = ps.customer_id