DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_IMPORT dependencies on CE_INTRA_STMT_HEADERS

Line 1096: from ce_intra_stmt_headers

1092: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1093: DELETE FROM CE_INTRA_STMT_LINES
1094: WHERE statement_header_id in
1095: (select statement_header_id
1096: from ce_intra_stmt_headers
1097: where statement_number = G_cshi_statement_number
1098: and bank_account_id in
1099: (select bank_account_id from ce_bank_accounts_v
1100: where bank_account_num = G_cshi_bank_account_num));

Line 1101: DELETE FROM CE_INTRA_STMT_HEADERS

1097: where statement_number = G_cshi_statement_number
1098: and bank_account_id in
1099: (select bank_account_id from ce_bank_accounts_v
1100: where bank_account_num = G_cshi_bank_account_num));
1101: DELETE FROM CE_INTRA_STMT_HEADERS
1102: WHERE statement_number = G_cshi_statement_number
1103: AND bank_account_id in
1104: (select bank_account_id from ce_bank_accounts_v
1105: where bank_account_num = G_cshi_bank_account_num);

Line 1107: select ce_intra_stmt_headers_s.nextval

1103: AND bank_account_id in
1104: (select bank_account_id from ce_bank_accounts_v
1105: where bank_account_num = G_cshi_bank_account_num);
1106:
1107: select ce_intra_stmt_headers_s.nextval
1108: into G_cshi_statement_header_id
1109: from sys.dual;
1110: INSERT INTO CE_INTRA_STMT_HEADERS (
1111: statement_header_id,

Line 1110: INSERT INTO CE_INTRA_STMT_HEADERS (

1106:
1107: select ce_intra_stmt_headers_s.nextval
1108: into G_cshi_statement_header_id
1109: from sys.dual;
1110: INSERT INTO CE_INTRA_STMT_HEADERS (
1111: statement_header_id,
1112: bank_account_id,
1113: statement_number,
1114: statement_date,