1437: WHERE ba.bank_account_id = p_bank.bank_account_id;
1438:
1439: SELECT count(1)
1440: INTO counter2
1441: FROM ce_cp_open_bal_v
1442: WHERE bank_account_id = p_bank.bank_account_id
1443: AND trunc(statement_date) < l_fc_start_date;
1444:
1445: IF counter2 > 0 THEN
1456: l_one_day_float,
1457: l_two_day_float,
1458: l_balance_date,
1459: l_bank_acc_curr
1460: FROM ce_cp_open_bal_v
1461: WHERE bank_account_id = p_bank.bank_account_id
1462: AND trunc(statement_date) < l_fc_start_date
1463: AND trunc(next_stmt_date) >= l_fc_start_date;
1464: