DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on FND_LOOKUP_VALUES

Line 112: csl_match_found FND_LOOKUP_VALUES.lookup_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;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;

Line 115: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%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;
116: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
117: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
118: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
119: csl_accounting_date CE_STATEMENT_LINES.accounting_date%TYPE;

Line 138: trx_currency_type FND_LOOKUP_VALUES.lookup_code%TYPE;

134: trx_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
135: trx_base_amount AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
136: trx_cleared_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
137: trx_curr_amount AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
138: trx_currency_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;

Line 169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;

165: trx_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
166: trx_base_amount2 AR_CASH_RECEIPT_HISTORY_ALL.acctd_amount%TYPE;
167: trx_cleared_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
168: trx_curr_amount2 AR_CASH_RECEIPT_HISTORY_ALL.amount%TYPE;
169: trx_currency_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
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;

Line 176: trx_type2 FND_LOOKUP_VALUES.lookup_code%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
180: -- it is one of the following when the match is found:

Line 183: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;

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: --
182: --
183: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);

Line 184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;

180: -- it is one of the following when the match is found:
181: --
182: --
183: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);
188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;

Line 185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;

181: --
182: --
183: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);
188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;
189: acctd_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;

Line 186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;

182: --
183: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
184: csl_match_type2 FND_LOOKUP_VALUES.lookup_code%TYPE;
185: trx_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
186: csl_match_correction_type FND_LOOKUP_VALUES.lookup_code%TYPE;
187: reconciled_this_run VARCHAR2(1);
188: tolerance_amount CE_STATEMENT_LINES.amount%TYPE;
189: acctd_exchange_rate CE_STATEMENT_LINES.exchange_rate%TYPE;
190: nsf_info_flag VARCHAR2(1) DEFAULT 'N';