APPS.AR_CMGT_AGING dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 208: FROM ar_payment_schedules_all ps

204: p_currency_code,
205: sysdate,
206: p_exchange_rate_type,
207: ps.amount_due_remaining)) bucket6
208: FROM ar_payment_schedules_all ps
209: WHERE payment_schedule_id +0 > 0
210: AND ps.class NOT IN ('GUAR', 'PMT')
211: --kjoshi bug#5169416
212: AND nvl(sign(ps.cons_inv_id),0) = decode(p_source,'CONS_BILL',1,0) --apandit BFB changes

Line 346: ar_payment_schedules_all ps,

342: (ra.amount_applied +
343: NVL(ra.earned_discount_taken,0)
344: + NVL(ra.unearned_discount_taken,0) ))) bucket6
345: FROM
346: ar_payment_schedules_all ps,
347: ar_receivable_applications_all ra
348: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
349: --kjoshi bug#5169416
350: AND nvl(sign(ps.cons_inv_id),0) = decode(p_source,'CONS_BILL',1,0)

Line 473: ar_payment_schedules_all ps

469: sysdate,
470: p_exchange_rate_type,
471: adj.acctd_amount)) bucket6
472: FROM ar_adjustments_all adj,
473: ar_payment_schedules_all ps
474: WHERE adj.payment_schedule_id = ps.payment_schedule_id
475: --kjoshi bug#5169416
476: AND nvl(sign(ps.cons_inv_id),0) = decode(p_source,'CONS_BILL',1,0) --apandit BFB changes
477: AND adj.apply_date > l_as_of_date

Line 611: FROM ar_payment_schedules_all ps,

607: p_exchange_rate_type,
608: (ra.amount_applied_from +
609: NVL(ra.earned_discount_taken,0)
610: + NVL(ra.unearned_discount_taken,0) ))) bucket6
611: FROM ar_payment_schedules_all ps,
612: ar_receivable_applications_all ra
613: WHERE
614: ps.payment_schedule_id +0 > 0
615: AND ra.payment_schedule_id = ps.payment_schedule_id