2780:
2781: --Initialise prog_int_char1 with Country Code
2782: UPDATE ZX_REGISTRATIONS_INT REG
2783: SET PROG_INT_CHAR1 = (SELECT COUNTRY_CODE 2784: FROM ZX_REGIMES_B TR 2785: WHERE TR.TAX_REGIME_CODE = REG.TAX_REGIME_CODE)
2786: WHERE request_id = G_REQUEST_ID
2787: AND PROG_INT_CHAR1 IS NULL
2788: AND TAX_REGIME_CODE IS NOT NULL