APPS.AR_IREC_PAYMENTS dependencies on RA_TERMS

Line 2226: RA_TERMS trm

2222: ( 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
2223: FROM AR_PAYMENT_SCHEDULES ps,
2224: RA_CUSTOMER_TRX ct,
2225: HZ_CUST_ACCOUNTS acct,
2226: RA_TERMS trm
2227: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')
2228: AND ps.customer_trx_id = ct.customer_trx_id
2229: AND acct.cust_account_id = ps.customer_id
2230: AND ps.status = 'OP'

Line 2497: RA_TERMS trm

2493: 0 dispute_amt
2494: FROM AR_PAYMENT_SCHEDULES ps,
2495: RA_CUSTOMER_TRX_ALL ct,
2496: HZ_CUST_ACCOUNTS acct,
2497: RA_TERMS trm
2498: WHERE ps.customer_id = p_customer_id
2499: AND ( ps.CLASS = 'CM'
2500: OR
2501: ps.CLASS = 'PMT'

Line 5172: RA_TERMS trm

5168: (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)) )
5169: FROM AR_PAYMENT_SCHEDULES ps,
5170: RA_CUSTOMER_TRX_ALL ct,
5171: HZ_CUST_ACCOUNTS acct,
5172: RA_TERMS trm
5173: WHERE ps.payment_schedule_id = p_payment_schedule_id
5174: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar
5175: AND ps.customer_trx_id = ct.customer_trx_id(+)
5176: AND acct.cust_account_id = ps.customer_id