145: gt.user_conversion_type,
146: curr.currency_code
147: FROM fnd_currencies curr,
148: gl_daily_conversion_types gt,
149: ce_transaction_codes ctc,
150: ce_statement_lines_interface l
151: WHERE curr.currency_code(+) = l.currency_code
152: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
153: AND ctc.trx_code(+) = l.trx_code
154: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id
155:
156: -- Code added for bug 7531187
157: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)
158: FROM ce_Transaction_Codes ctc2
159: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
160: AND ctc2.trx_Code (+) = l.trx_Code)
161: -- End of Code for bug 7531187
162:
893: csli.attribute12,
894: csli.attribute13,
895: csli.attribute14,
896: csli.attribute15
897: FROM ce_transaction_codes ctc,
898: ce_statement_lines_interface csli,
899: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
900: WHERE ctc.trx_code(+) = csli.trx_code
901: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
951: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
952: csli.line_number,
953: csli.trx_date,
954: (select distinct ctc.trx_type
955: from ce_transaction_codes ctc
956: where ctc.trx_code(+) = csli.trx_code
957: AND NVL(ctc.bank_account_id,aba.bank_account_id) =
958: aba.bank_account_id),
959: csli.trx_code, --ctc.transaction_code_id,
999: csli.attribute12,
1000: csli.attribute13,
1001: csli.attribute14,
1002: csli.attribute15
1003: FROM --ce_transaction_codes ctc,
1004: gl_daily_conversion_types gdct,
1005: ce_statement_lines_interface csli,
1006: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1007: WHERE gdct.user_conversion_type(+) = csli.user_exchange_rate_type
1498: -- We need to do this because of the control total validation relies on these codes
1499: --
1500: SELECT count(*)
1501: INTO trx_code_count
1502: FROM ce_transaction_codes
1503: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1504: IF (trx_code_count = 0) THEN
1505: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1506: END IF;
1829: r_statement_number CE_STATEMENT_HEADERS.statement_number%TYPE;
1830: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1831: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1832: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1833: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1834: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1835: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1836: line_error_found BOOLEAN;
1837: l_error_found BOOLEAN;
1830: r_user_conversion_type GL_DAILY_CONVERSION_TYPES.user_conversion_type%TYPE;
1831: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1832: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1833: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1834: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1835: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1836: line_error_found BOOLEAN;
1837: l_error_found BOOLEAN;
1838: header_error_found BOOLEAN;
1831: r_exchange_rate_type GL_DAILY_CONVERSION_TYPES.conversion_type%TYPE;
1832: r_currency_code FND_CURRENCIES.currency_code%TYPE;
1833: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
1834: r_start_date CE_TRANSACTION_CODES.start_date%TYPE;
1835: r_end_date CE_TRANSACTION_CODES.end_date%TYPE;
1836: line_error_found BOOLEAN;
1837: l_error_found BOOLEAN;
1838: header_error_found BOOLEAN;
1839: lock_error_found BOOLEAN;