DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 3673: , ar_cash_receipt_history_all acrh --Added by Qiong for bug13555753

3669: , jcra.exchange_rate_type
3670: FROM
3671: jai_ar_cash_receipts_all jcra
3672: , ar_cash_receipts_all acra
3673: , ar_cash_receipt_history_all acrh --Added by Qiong for bug13555753
3674: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3675: AND jcra.confirm_flag = 'Y'
3676: AND jcra.document_type = 'Service'
3677: AND acra.reversal_date IS NOT NULL

Line 5785: FROM ar_cash_receipt_history_all

5781: /*Added by Qinglei on 12-Jan-2012 for bug#13569242 begin*/
5782: CURSOR cur_get_rcpt_reversal_gl_date
5783: IS
5784: SELECT gl_date
5785: FROM ar_cash_receipt_history_all
5786: WHERE cash_receipt_id = p_acra.cash_receipt_id
5787: AND status = 'REVERSED';
5788: /*Added by Qinglei on 12-Jan-2012 for bug#13569242 end*/
5789: CURSOR cur_get_unapplied_account