APPS.CE_AUTO_BANK_IMPORT dependencies on CE_BANK_ACCT_BALANCES

Line 259: FROM CE_BANK_ACCT_BALANCES

255: l_return number:=0;
256: BEGIN
257: SELECT 1
258: INTO l_return
259: FROM CE_BANK_ACCT_BALANCES
260: WHERE BANK_ACCOUNT_ID = p_bank_account_id
261: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
262: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
263: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)

Line 1220: from ce_bank_acct_balances

1216: end if;
1217:
1218: select count(1)
1219: into x_bal_count
1220: from ce_bank_acct_balances
1221: where bank_account_id = aba_bank_account_id
1222: and balance_date = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
1223:
1224: IF x_bal_count > 0 THEN

Line 1309: SELECT CE_BANK_ACCT_BALANCES_S.nextval

1305: X_global_attribute19 => NULL,
1306: X_global_attribute20 => NULL
1307: );
1308: ELSE
1309: SELECT CE_BANK_ACCT_BALANCES_S.nextval
1310: INTO X_bank_acct_balance_id
1311: FROM SYS.dual;
1312:
1313: INSERT INTO CE_BANK_ACCT_BALANCES

Line 1313: INSERT INTO CE_BANK_ACCT_BALANCES

1309: SELECT CE_BANK_ACCT_BALANCES_S.nextval
1310: INTO X_bank_acct_balance_id
1311: FROM SYS.dual;
1312:
1313: INSERT INTO CE_BANK_ACCT_BALANCES
1314: (bank_acct_balance_id,
1315: bank_account_id,
1316: balance_date,
1317: ledger_balance,