DBA Data[Home] [Help]

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_SUBSCRIPTION_OPTIONS

Line 3349: FROM zx_subscription_options

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
3351: IN (SELECT REGIME_USAGE_ID
3352: FROM ZX_REGIMES_USAGES
3353: WHERE tax_regime_code = c_tax_regime_code

Line 3389: SELECT zx_subscription_options_s.nextval

3385: SELECT zx_regimes_usages_s.nextval
3386: INTO l_regime_usage_id
3387: FROM dual;
3388:
3389: SELECT zx_subscription_options_s.nextval
3390: INTO l_sub_opt_id
3391: FROM dual;
3392:
3393: INSERT INTO zx_regimes_usages

Line 3417: INSERT INTO zx_subscription_options

3413: P_LAST_UPDATED_BY,
3414: P_LAST_UPDATE_DATE,
3415: P_LAST_UPDATE_LOGIN);
3416:
3417: INSERT INTO zx_subscription_options
3418: (SUBSCRIPTION_OPTION_ID,
3419: SUBSCRIPTION_OPTION_CODE,
3420: REGIME_USAGE_ID,
3421: EFFECTIVE_FROM,