810: l_key VARCHAR2(100);
811: l_insert BOOLEAN ;
812:
813: -- Added this cursor to fetch the data from
814: -- ZX_SCO_TAXES_B_V in place of ZX_SCO_TAXES
815: CURSOR get_tax_id (c_tax_regime_code VARCHAR2,
816: c_tax VARCHAR2)
817: IS
818: SELECT tax_id,Def_Place_Of_Supply_Type_Code --Bug 12688194
815: CURSOR get_tax_id (c_tax_regime_code VARCHAR2,
816: c_tax VARCHAR2)
817: IS
818: SELECT tax_id,Def_Place_Of_Supply_Type_Code --Bug 12688194
819: FROM zx_sco_taxes_b_v
820: WHERE tax = c_tax
821: AND tax_regime_code = c_tax_regime_code
822: ORDER BY subscription_level_code;
823: