1753: FROM jl_co_gl_nits jlcgn1,
1754: jl_co_gl_nits jlcgn,
1755: ap_bank_branches apbb1,
1756: ap_bank_branches apbb,
1757: ap_bank_accounts_all apbaa,
1758: ar_cash_receipts_all arcra
1759: WHERE arcra.cash_receipt_id = TO_NUMBER(ar_trx.reference_2)
1760: AND arcra.set_of_books_id = g_parameter_rec.set_of_books_id
1761: AND arcra.remittance_bank_account_id = apbaa.bank_account_id