128: --
129:
130: SELECT cash_receipt_id
131: INTO X_cash_receipt_id
132: FROM ar_cash_receipt_history_all
133: WHERE cash_receipt_history_id = X_reference_id;
134:
135: BEGIN
136: SELECT trx_type
342: -- If the receipt is DM Reversed then assign the reference_type to be 'DM REVERSAL'
343: --
344: SELECT cash_receipt_id
345: INTO X_cash_receipt_id
346: FROM ar_cash_receipt_history_all
347: WHERE cash_receipt_history_id = X_reference_id;
348:
349: BEGIN
350: SELECT trx_type