[Home] [Help]
148: CURSOR c_get_reg_rep_coll_ids is
149: SELECT REP_TAX_AUTHORITY_ID,
150: COLL_TAX_AUTHORITY_ID,
151: REGISTRATION_ID
152: FROM ZX_REGISTRATIONS
153: WHERE TAX_REGIME_CODE = p_tax_regime_code
154: AND TAX = p_tax
155: AND TAX_JURISDICTION_CODE IS NULL;
156: l_rep_coll_ids c_get_reg_rep_coll_ids%ROWTYPE;
175: ELSE
176: l_coll_tax_authority_id:=l_rep_coll_ids.COLL_TAX_AUTHORITY_ID;
177: END IF;
178: IF l_update_required THEN
179: UPDATE ZX_REGISTRATIONS
180: SET REP_TAX_AUTHORITY_ID = l_rep_tax_authority_id,
181: COLL_TAX_AUTHORITY_ID = l_coll_tax_authority_id
182: WHERE REGISTRATION_ID = l_rep_coll_ids.REGISTRATION_ID;
183: End if;
1184: l_old_zone_geo_type ZX_TAXES_B.ZONE_GEOGRAPHY_TYPE%TYPE;
1185: l_old_parent_geo_type ZX_TAXES_B.PARENT_GEOGRAPHY_TYPE%TYPE;
1186: l_old_parent_geo_id ZX_TAXES_B.PARENT_GEOGRAPHY_ID%TYPE;
1187: begin
1188: /*Logic to update ZX_JURISDICTIONS/ZX_REGISTRATIONS table if the Reporting and/or Collecting Tax Authorities have bee
1189: n changed*/
1190: open c_old_ref_values;
1191: fetch c_old_ref_values into l_old_references;
1192: if((NVL(l_old_references.REP_TAX_AUTHORITY_ID,-99)<> NVL(X_REP_TAX_AUTHORITY_ID,-99) OR