APPS.AR_GET_CUSTOMER_BALANCE_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 230: FROM ar_cash_receipt_history crh

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

Line 251: FROM ar_cash_receipt_history crh

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

Line 257: FROM ar_cash_receipt_history crh

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

Line 385: FROM ar_cash_receipt_history crh

381: AND ra.status in ('ACC' , 'UNAPP' )
382: AND ra.application_rule <> 'RATE ADJUSTMENT TRIGGER'
383: AND NOT EXISTS (
384: SELECT 'reversed'
385: FROM ar_cash_receipt_history crh
386: WHERE ra.cash_receipt_id = crh.cash_receipt_id
387: AND crh.status = 'REVERSED'
388: AND crh.trx_date+0 <= p_as_of_date ) ;
389:

Line 408: FROM ar_cash_receipt_history crh

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

Line 414: FROM ar_cash_receipt_history crh

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