APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 228: FROM ar_cash_receipt_history crh

224: AND status||'' = 'APP'
225: AND application_type= 'CASH'
226: AND NOT EXISTS (
227: SELECT 'reversed'
228: FROM ar_cash_receipt_history crh
229: WHERE ra.cash_receipt_id = crh.cash_receipt_id
230: AND crh.status = 'REVERSED'
231: AND crh.trx_date+0 <= p_as_of_date ) ;
232:

Line 249: FROM ar_cash_receipt_history crh

245: AND status||'' = 'APP'
246: AND application_type= 'CASH'
247: AND NOT EXISTS (
248: SELECT 'reversed'
249: FROM ar_cash_receipt_history crh
250: WHERE ra.cash_receipt_id = crh.cash_receipt_id
251: AND crh.status = 'REVERSED'
252: AND crh.trx_date+0 <= p_as_of_date )
253: AND EXISTS (

Line 255: FROM ar_cash_receipt_history crh

251: AND crh.status = 'REVERSED'
252: AND crh.trx_date+0 <= p_as_of_date )
253: AND EXISTS (
254: SELECT 'cleared'
255: FROM ar_cash_receipt_history crh
256: WHERE ra.cash_receipt_id = crh.cash_receipt_id
257: AND crh.status = 'CLEARED'
258: AND crh.trx_date+0 <= p_as_of_date ) ;
259:

Line 382: FROM ar_cash_receipt_history crh

378: AND ra.apply_date+0 <= p_as_of_date
379: AND ra.status in ('ACC' , 'UNAPP' )
380: AND NOT EXISTS (
381: SELECT 'reversed'
382: FROM ar_cash_receipt_history crh
383: WHERE ra.cash_receipt_id = crh.cash_receipt_id
384: AND crh.status = 'REVERSED'
385: AND crh.trx_date+0 <= p_as_of_date ) ;
386:

Line 405: FROM ar_cash_receipt_history crh

401: AND apply_date+0 <= p_as_of_date
402: AND ra.status in ('ACC' , 'UNAPP' )
403: AND NOT EXISTS (
404: SELECT 'reversed'
405: FROM ar_cash_receipt_history crh
406: WHERE ra.cash_receipt_id = crh.cash_receipt_id
407: AND crh.status = 'REVERSED'
408: AND crh.trx_date+0 <= p_as_of_date )
409: AND EXISTS (

Line 411: FROM ar_cash_receipt_history crh

407: AND crh.status = 'REVERSED'
408: AND crh.trx_date+0 <= p_as_of_date )
409: AND EXISTS (
410: SELECT 'cleared'
411: FROM ar_cash_receipt_history crh
412: WHERE ra.cash_receipt_id = crh.cash_receipt_id
413: AND crh.status = 'CLEARED'
414: AND crh.trx_date+0 <= p_as_of_date ) ;
415: