235: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
236: UNION
237: SELECT Rct.Trx_Number Trx_Receipt_Number
238: FROM RA_CUSTOMER_TRX_ALL Rct,
239: AR_ADJUSTMENTS_ALL Adj,
240: Xla_Transaction_Entities Ent,
241: Xla_Ae_Headers Aeh
242: WHERE Adj.Customer_Trx_Id = Rct.Customer_Trx_Id
243: AND Ent.Application_Id = 222