eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CE_AUTO_BANK_IMPORT dependencies on CE_INTRA_STMT_HEADERS

Line 1107: from ce_intra_stmt_headers

1103: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1104: DELETE FROM CE_INTRA_STMT_LINES
1105: WHERE statement_header_id in
1106: (select statement_header_id
1107: from ce_intra_stmt_headers
1108: where statement_number = G_cshi_statement_number
1109: and bank_account_id in
1110: (select bank_account_id from ce_bank_accounts_v
1111: where bank_account_num = G_cshi_bank_account_num));

Line 1112: DELETE FROM CE_INTRA_STMT_HEADERS

1108: where statement_number = G_cshi_statement_number
1109: and bank_account_id in
1110: (select bank_account_id from ce_bank_accounts_v
1111: where bank_account_num = G_cshi_bank_account_num));
1112: DELETE FROM CE_INTRA_STMT_HEADERS
1113: WHERE statement_number = G_cshi_statement_number
1114: AND bank_account_id in
1115: (select bank_account_id from ce_bank_accounts_v
1116: where bank_account_num = G_cshi_bank_account_num);

Line 1118: select ce_intra_stmt_headers_s.nextval

1114: AND bank_account_id in
1115: (select bank_account_id from ce_bank_accounts_v
1116: where bank_account_num = G_cshi_bank_account_num);
1117:
1118: select ce_intra_stmt_headers_s.nextval
1119: into G_cshi_statement_header_id
1120: from sys.dual;
1121: INSERT INTO CE_INTRA_STMT_HEADERS (
1122: statement_header_id,

Line 1121: INSERT INTO CE_INTRA_STMT_HEADERS (

1117:
1118: select ce_intra_stmt_headers_s.nextval
1119: into G_cshi_statement_header_id
1120: from sys.dual;
1121: INSERT INTO CE_INTRA_STMT_HEADERS (
1122: statement_header_id,
1123: bank_account_id,
1124: statement_number,
1125: statement_date,