APPS.XTR_AUTO_RECONCILIATION dependencies on XTR_PAY_REC_RECONCILIATION_V

Line 27: XTR_PAY_REC_RECONCILIATION_V prr

23: itr.account_number
24: from xtr_source_of_imports_v sim,
25: xtr_available_for_recon_v are,
26: xtr_import_trailer_details_v itr,
27: XTR_PAY_REC_RECONCILIATION_V prr
28: where sim.source = itr.source
29: AND are.import_reference = itr.import_reference
30: AND prr.import_reference = are.import_reference
31: AND prr.import_reference = itr.import_reference

Line 350: from XTR_PAY_REC_RECONCILIATION_V

346: and TRANSACTION_NUMBER = l_trans_no;
347: -- Created cursor Bug 4226409
348: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
349: select VALUE_DATE
350: from XTR_PAY_REC_RECONCILIATION_V
351: where RECONCILED_REFERENCE = p_rec_ref ;
352: --
353: BEGIN
354: -- set parameters