APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_REGIMES_B

Line 1709: | ZX_TAXES_B,ZX_REGIMES_B and also creates

1705: | eBTax entities for both Tax Definition and
1706: | default AP tax hierarchy setup.
1707: | For Tax Definition entities:-
1708: | Creates associated ZX_RATES_B,ZX_STATUS_B,
1709: | ZX_TAXES_B,ZX_REGIMES_B and also creates
1710: | ZX_CONDITIONS, ZX_RULES_B,ZX_PROCESS_RESULTS
1711: | based on recoveryr rates(rules) setup of
1712: | newly created Tax codes.
1713: | For Tax Default Hierarchy:-

Line 3342: FROM zx_regimes_b

3338: AND party_type_code = 'OU';
3339:
3340: CURSOR regm_id IS
3341: SELECT tax_regime_id,effective_from
3342: FROM zx_regimes_b
3343: WHERE tax_regime_code = P_TAX_REGIME_CODE;
3344:
3345:
3346: CURSOR sub_usage_id_cur (c_tax_regime_code zx_regimes_b.tax_regime_code%type,

Line 3346: CURSOR sub_usage_id_cur (c_tax_regime_code zx_regimes_b.tax_regime_code%type,

3342: FROM zx_regimes_b
3343: WHERE tax_regime_code = P_TAX_REGIME_CODE;
3344:
3345:
3346: CURSOR sub_usage_id_cur (c_tax_regime_code zx_regimes_b.tax_regime_code%type,
3347: c_pty_org_id NUMBER)IS
3348: SELECT COUNT(*)
3349: FROM zx_subscription_options
3350: WHERE REGIME_USAGE_ID