DBA Data[Home] [Help]

APPS.AR_ECAPP_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 117: FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh ,

113:
114: CURSOR C1 IS
115: SELECT cr.cash_receipt_id, cr.receipt_number, cr.org_id,
116: summ.bepcode, summ.bepmessage, summ.instrtype
117: FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh ,
118: ar_settlement_errors_gt gt, iby_trxn_summaries_all summ,
119: iby_fndcpt_tx_operations op
120: WHERE gt.req_type in ('ORAPMTCAPTURE', 'ORAPMTRETURN', 'ORAPMTCREDIT', 'ORAPMTVOID', 'ORAPMTBATCHREQ')
121: AND summ.transactionid = gt.txn_id

Line 276: ar_cash_receipt_history_all crh

272:
273: SELECT DISTINCT cr.request_id , cr.org_id
274: BULK COLLECT INTO l_request_id, l_cc_org_id
275: FROM ar_cash_receipts_all cr,
276: ar_cash_receipt_history_all crh
277: WHERE cr.cash_receipt_id = crh.cash_receipt_id
278: AND cr.org_id = crh.org_id
279: AND cr.cc_error_flag = 'Y'
280: AND crh.status = 'CONFIRMED'