1775: fetch c_cess_amount into ln_Cess_amount;
1776: close c_cess_amount;
1777:
1778: lv_register_type := 'RG23A';
1779: jai_cmn_rg_others_pkg.check_balances(
1780: p_organization_id => v_org_id ,
1781: p_location_id => v_loc_id ,
1782: p_register_type => lv_register_type ,
1783: p_trx_amount => ln_cess_amount ,
1792: end if;
1793:
1794:
1795: lv_register_type := 'RG23C';
1796: jai_cmn_rg_others_pkg.check_balances(
1797: p_organization_id => v_org_id ,
1798: p_location_id => v_loc_id ,
1799: p_register_type => lv_register_type ,
1800: p_trx_amount => ln_cess_amount ,
1809: end if;
1810:
1811:
1812: lv_register_type := 'PLA';
1813: jai_cmn_rg_others_pkg.check_balances(
1814: p_organization_id => v_org_id ,
1815: p_location_id => v_loc_id ,
1816: p_register_type => lv_register_type ,
1817: p_trx_amount => ln_cess_amount ,