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 462: from XTR_PAY_REC_RECONCILIATION_V

458: SELECT statement_line_id FROM ce_statement_reconcils_all WHERE reference_id in
459: (SELECT settlement_summary_id FROM xtr_settlement_summary WHERE settlement_number
460: IN (SELECT settlement_number FROM xtr_deal_date_amounts WHERE reconciled_reference = p_rec_ref )));
461: /* select VALUE_DATE
462: from XTR_PAY_REC_RECONCILIATION_V
463: where RECONCILED_REFERENCE = p_rec_ref ; */
464: --
465: BEGIN
466: -- set parameters

Line 627: from XTR_PAY_REC_RECONCILIATION_V

623: and TRANSACTION_NUMBER = l_trans_no;
624: -- Created cursor Bug 4226409
625: CURSOR SETTLE_DATE(p_rec_ref NUMBER) is
626: select VALUE_DATE
627: from XTR_PAY_REC_RECONCILIATION_V
628: where RECONCILED_REFERENCE = p_rec_ref ;
629: --
630: BEGIN
631: -- set parameters