APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_REGIMES_USAGES

Line 3352: FROM ZX_REGIMES_USAGES

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
3354: AND FIRST_PTY_ORG_ID = c_pty_org_id);
3355:
3356: l_pty_org_id NUMBER;

Line 3385: SELECT zx_regimes_usages_s.nextval

3381: IF sub_usage_id_cur%NOTFOUND THEN
3382: BEGIN
3383: arp_util_tax.debug('sub_usage_id_cur NOTFOUND :');
3384:
3385: SELECT zx_regimes_usages_s.nextval
3386: INTO l_regime_usage_id
3387: FROM dual;
3388:
3389: SELECT zx_subscription_options_s.nextval

Line 3393: INSERT INTO zx_regimes_usages

3389: SELECT zx_subscription_options_s.nextval
3390: INTO l_sub_opt_id
3391: FROM dual;
3392:
3393: INSERT INTO zx_regimes_usages
3394: (regime_usage_id,
3395: first_pty_org_id,
3396: tax_regime_id,
3397: tax_regime_code,