APPS.ARP_PROCESS_WRITEOFF dependencies on AR_PAYMENT_SCHEDULES

Line 327: FROM ar_payment_schedules ps,

323: SUM(DECODE(app.status,'ACTIVITY',DECODE(applied_payment_schedule_id,-3,
324: DECODE(app.created_by,c_user_id,
325: NVL(app.amount_applied_from,app.amount_applied),0),0),0)) written_off_amount,
326: crh.batch_id batch_id
327: FROM ar_payment_schedules ps,
328: ar_cash_receipts acr,
329: ar_cash_receipt_history crh,
330: ar_receivable_applications app
331: WHERE ps.invoice_currency_code = c_receipt_currency_code