APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 209: FROM ar_receivable_applications

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

Line 223: FROM ar_receivable_applications ra

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

Line 244: FROM ar_receivable_applications ra

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

Line 269: FROM ar_receivable_applications

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

Line 374: FROM ar_receivable_applications ra,

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

Line 398: FROM ar_receivable_applications ra,

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