105: csl_reconcile_flag CE_TRANSACTION_CODES.reconcile_flag%TYPE;
106: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
106: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
114: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
107: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
108: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
109: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
110: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
111: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
112: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
113: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
114: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
115: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
139: trx_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
140: trx_errors_amount CE_STATEMENT_LINES.amount%TYPE;
141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);
140: trx_errors_amount CE_STATEMENT_LINES.amount%TYPE;
141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);
148: trx_gl_date DATE;
141: trx_charges_amount CE_STATEMENT_LINES.amount%TYPE;
142: trx_prorate_amount CE_STATEMENT_LINES.amount%TYPE;
143: trx_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
144: trx_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
145: trx_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
146: trx_customer_id NUMBER; --RA_CUSTOMERS.customer_id%TYPE;
147: reversed_receipt_flag VARCHAR2(1);
148: trx_gl_date DATE;
149: trx_group VARCHAR2(100);
170: trx_status2 AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
171: trx_errors_amount2 CE_STATEMENT_LINES.amount%TYPE;
172: trx_charges_amount2 CE_STATEMENT_LINES.amount%TYPE;
173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --
171: trx_errors_amount2 CE_STATEMENT_LINES.amount%TYPE;
172: trx_charges_amount2 CE_STATEMENT_LINES.amount%TYPE;
173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --
179: -- csl_match_type is blank when there is no matching transaction
173: trx_prorate_amount2 CE_STATEMENT_LINES.amount%TYPE;
174: trx_exchange_rate_type2 GL_DAILY_RATES.conversion_type%TYPE;
175: trx_exchange_rate_date2 GL_DAILY_RATES.conversion_date%TYPE;
176: trx_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
177: trx_exchange_rate2 GL_DAILY_RATES.conversion_rate%TYPE;
178: --
179: -- csl_match_type is blank when there is no matching transaction
180: -- it is one of the following when the match is found:
181: --