APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 207: FROM ar_receivable_applications

203:
204: -- For CM, get application
205: SELECT NVL(SUM(amount_applied) , 0 ) amount_applied
206: INTO l_amount_applied_cm /*bug4502121*/
207: FROM ar_receivable_applications
208: WHERE payment_schedule_id = tot_inv_rec.payment_schedule_id
209: AND apply_date <= p_as_of_date
210: AND status||'' = 'APP';
211:

Line 221: FROM ar_receivable_applications ra

217: NVL(SUM(unearned_discount_taken) ,0) unearned_discount_taken
218: INTO l_amount_applied
219: , l_earned_discount_taken
220: , l_unearned_discount_taken
221: FROM ar_receivable_applications ra
222: WHERE applied_payment_schedule_id = tot_inv_rec.payment_schedule_id
223: AND apply_date <= p_as_of_date
224: AND status||'' = 'APP'
225: AND application_type= 'CASH'

Line 242: FROM ar_receivable_applications ra

238: NVL(SUM(unearned_discount_taken) ,0) unearned_discount_taken
239: INTO l_amount_applied
240: , l_earned_discount_taken
241: , l_unearned_discount_taken
242: FROM ar_receivable_applications ra
243: WHERE applied_payment_schedule_id = tot_inv_rec.payment_schedule_id
244: AND apply_date<= p_as_of_date
245: AND status||'' = 'APP'
246: AND application_type= 'CASH'

Line 267: FROM ar_receivable_applications

263:
264: -- CM Application
265: SELECT NVL(SUM(amount_applied) , 0 ) amount_applied
266: INTO l_amount_credited
267: FROM ar_receivable_applications
268: WHERE applied_payment_schedule_id = tot_inv_rec.payment_schedule_id
269: AND apply_date <= p_as_of_date
270: AND status||'' = 'APP'
271: AND application_type= 'CM' ;

Line 372: FROM ar_receivable_applications ra,

368: SELECT nvl(sum(decode(ra.status , 'ACC', amount_applied, 0 )),0),
369: nvl(sum(decode(ra.status ,'UNAPP',amount_applied, 0 )),0)
370: INTO l_on_acct_receipts ,
371: l_unapp_receipts
372: FROM ar_receivable_applications ra,
373: ar_cash_receipts cr
374: WHERE ra.cash_receipt_id = cr.cash_receipt_id
375: AND cr.pay_from_customer = cusinfo_rec.customer_id
376: AND cr.customer_site_use_id = siteinfo_rec.site_use_id

Line 395: FROM ar_receivable_applications ra,

391: SELECT nvl(sum(decode(ra.status , 'ACC', amount_applied, 0 )),0),
392: nvl(sum(decode(ra.status , 'UNAPP', amount_applied, 0)),0)
393: INTO l_on_acct_receipts ,
394: l_unapp_receipts
395: FROM ar_receivable_applications ra,
396: ar_cash_receipts cr
397: WHERE ra.cash_receipt_id = cr.cash_receipt_id
398: AND cr.pay_from_customer = cusinfo_rec.customer_id
399: AND cr.currency_code = currency_rec.currency_code