DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on IBY_TRXN_EXTENSIONS_V

Line 5770: iby_trxn_extensions_v trxn_ext

5766: WHERE cash_receipt_id in (
5767: SELECT cr.cash_receipt_id
5768: FROM ar_cash_receipts cr,
5769: ar_cash_receipt_history crh,
5770: iby_trxn_extensions_v trxn_ext
5771: WHERE crh.request_id = l_request_id
5772: AND crh.status = 'REMITTED'
5773: AND crh.current_record_flag = 'Y'
5774: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5822: iby_trxn_extensions_v trxn_ext

5818: l_program_id,
5819: sysdate
5820: FROM ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: iby_trxn_extensions_v trxn_ext
5823: WHERE crh.request_id = l_request_id
5824: AND crh.status = 'REMITTED'
5825: AND crh.current_record_flag = 'Y'
5826: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5851: iby_trxn_extensions_v trxn_ext

5847: WHERE cash_receipt_id in (
5848: SELECT cr.cash_receipt_id
5849: FROM ar_cash_receipts cr,
5850: ar_cash_receipt_history crh,
5851: iby_trxn_extensions_v trxn_ext
5852: WHERE crh.request_id = l_request_id
5853: AND crh.status = 'REMITTED'
5854: AND crh.current_record_flag = 'Y'
5855: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5903: iby_trxn_extensions_v trxn_ext

5899: l_program_id,
5900: sysdate
5901: FROM ar_cash_receipts cr,
5902: ar_cash_receipt_history crh,
5903: iby_trxn_extensions_v trxn_ext
5904: WHERE crh.request_id = l_request_id
5905: AND crh.status = 'REMITTED'
5906: AND crh.current_record_flag = 'Y'
5907: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5950: iby_trxn_extensions_v trxn_ext

5946: WHERE cash_receipt_id in (
5947: SELECT cr.cash_receipt_id
5948: FROM ar_cash_receipts cr,
5949: ar_cash_receipt_history crh,
5950: iby_trxn_extensions_v trxn_ext
5951: WHERE cr.request_id = p_request_id
5952: AND cr.cc_error_flag = 'Y'
5953: AND cr.type = 'CASH'
5954: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5977: iby_trxn_extensions_v trxn_ext

5973: WHERE cash_receipt_id in (
5974: SELECT cr.cash_receipt_id
5975: FROM ar_cash_receipts cr,
5976: ar_cash_receipt_history crh,
5977: iby_trxn_extensions_v trxn_ext
5978: WHERE cr.request_id = p_request_id
5979: AND cr.cc_error_flag = 'Y'
5980: AND cr.type = 'MISC'
5981: AND crh.cash_receipt_id = cr.cash_receipt_id