APPS.CE_AUTO_BANK_IMPORT dependencies on CE_BANK_ACCT_BALANCES

Line 251: FROM CE_BANK_ACCT_BALANCES

247: l_return number:=0;
248: BEGIN
249: SELECT 1
250: INTO l_return
251: FROM CE_BANK_ACCT_BALANCES
252: WHERE BANK_ACCOUNT_ID = p_bank_account_id
253: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
254: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
255: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)

Line 1207: from ce_bank_acct_balances

1203: end if;
1204:
1205: select count(1)
1206: into x_bal_count
1207: from ce_bank_acct_balances
1208: where bank_account_id = aba_bank_account_id
1209: and balance_date = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
1210:
1211: IF x_bal_count > 0 THEN

Line 1296: SELECT CE_BANK_ACCT_BALANCES_S.nextval

1292: X_global_attribute19 => NULL,
1293: X_global_attribute20 => NULL
1294: );
1295: ELSE
1296: SELECT CE_BANK_ACCT_BALANCES_S.nextval
1297: INTO X_bank_acct_balance_id
1298: FROM SYS.dual;
1299:
1300: INSERT INTO CE_BANK_ACCT_BALANCES

Line 1300: INSERT INTO CE_BANK_ACCT_BALANCES

1296: SELECT CE_BANK_ACCT_BALANCES_S.nextval
1297: INTO X_bank_acct_balance_id
1298: FROM SYS.dual;
1299:
1300: INSERT INTO CE_BANK_ACCT_BALANCES
1301: (bank_acct_balance_id,
1302: bank_account_id,
1303: balance_date,
1304: ledger_balance,