141: WHEN NO_DATA_FOUND THEN
142: X_statement_type := 'X';
143: END;
144:
145: IF (arp_cashbook.receipt_debit_memo_reversed(X_cash_receipt_id)='Y')
146: and (X_statement_type IN ('NSF', 'REJECTED')) THEN
147: reference_type_tmp := 'DM REVERSAL';
148: ELSE
149: reference_type_tmp := 'RECEIPT';
356: X_statement_type := 'X';
357: END;
358:
359:
360: IF (arp_cashbook.receipt_debit_memo_reversed(X_cash_receipt_id)='Y')
361: and (X_statement_type IN ('NSF', 'REJECTED')) THEN
362: reference_type_tmp := 'DM REVERSAL';
363: ELSE
364: reference_type_tmp := 'RECEIPT';