APPS.CE_AUTO_BANK_IMPORT dependencies on CE_TRANSACTION_CODES

Line 149: ce_transaction_codes ctc,

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

Line 158: FROM ce_Transaction_Codes ctc2

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:

Line 897: FROM ce_transaction_codes ctc,

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) =

Line 955: from ce_transaction_codes ctc

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,

Line 1003: FROM --ce_transaction_codes ctc,

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

Line 1502: FROM ce_transaction_codes

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;

Line 1833: r_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;

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;

Line 1834: r_start_date CE_TRANSACTION_CODES.start_date%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;
1838: header_error_found BOOLEAN;

Line 1835: r_end_date CE_TRANSACTION_CODES.end_date%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;
1839: lock_error_found BOOLEAN;