Advanced Orcale plsql

Using Plsql and toad tool

1-Fill payment installments number

2-Fill installments paid table by insert

- contract_id

- insatallment_date

based on contract type

according to (annual-quarter-half annual- monthly)

- installment_amount

check for any deposit paid subtract it from contract_total_fees