DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on IBY_TRXN_EXTENSIONS_V

Line 5463: iby_trxn_extensions_v trxn_ext

5459: WHERE cash_receipt_id in (
5460: SELECT cr.cash_receipt_id
5461: FROM ar_cash_receipts cr,
5462: ar_cash_receipt_history crh,
5463: iby_trxn_extensions_v trxn_ext
5464: WHERE crh.request_id = l_request_id
5465: AND crh.status = 'REMITTED'
5466: AND crh.current_record_flag = 'Y'
5467: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5515: iby_trxn_extensions_v trxn_ext

5511: l_program_id,
5512: sysdate
5513: FROM ar_cash_receipts cr,
5514: ar_cash_receipt_history crh,
5515: iby_trxn_extensions_v trxn_ext
5516: WHERE crh.request_id = l_request_id
5517: AND crh.status = 'REMITTED'
5518: AND crh.current_record_flag = 'Y'
5519: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5544: iby_trxn_extensions_v trxn_ext

5540: WHERE cash_receipt_id in (
5541: SELECT cr.cash_receipt_id
5542: FROM ar_cash_receipts cr,
5543: ar_cash_receipt_history crh,
5544: iby_trxn_extensions_v trxn_ext
5545: WHERE crh.request_id = l_request_id
5546: AND crh.status = 'REMITTED'
5547: AND crh.current_record_flag = 'Y'
5548: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5596: iby_trxn_extensions_v trxn_ext

5592: l_program_id,
5593: sysdate
5594: FROM ar_cash_receipts cr,
5595: ar_cash_receipt_history crh,
5596: iby_trxn_extensions_v trxn_ext
5597: WHERE crh.request_id = l_request_id
5598: AND crh.status = 'REMITTED'
5599: AND crh.current_record_flag = 'Y'
5600: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5643: iby_trxn_extensions_v trxn_ext

5639: WHERE cash_receipt_id in (
5640: SELECT cr.cash_receipt_id
5641: FROM ar_cash_receipts cr,
5642: ar_cash_receipt_history crh,
5643: iby_trxn_extensions_v trxn_ext
5644: WHERE cr.request_id = p_request_id
5645: AND cr.cc_error_flag = 'Y'
5646: AND cr.type = 'CASH'
5647: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5670: iby_trxn_extensions_v trxn_ext

5666: WHERE cash_receipt_id in (
5667: SELECT cr.cash_receipt_id
5668: FROM ar_cash_receipts cr,
5669: ar_cash_receipt_history crh,
5670: iby_trxn_extensions_v trxn_ext
5671: WHERE cr.request_id = p_request_id
5672: AND cr.cc_error_flag = 'Y'
5673: AND cr.type = 'MISC'
5674: AND crh.cash_receipt_id = cr.cash_receipt_id