APPS.ZX_UPGRADE_CONTROL_PKG dependencies on DUAL

Line 1868: FROM DUAL;

1864: p_global_attribute1,
1865: zx_migrate_util.GET_TAX(p_name,
1866: p_tax_type)
1867: ) INTO l_tax
1868: FROM DUAL;
1869:
1870: -- Bug 3751717
1871: IF p_tax_type NOT IN('OFFSET','USE') THEN
1872: Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);

Line 3387: FROM dual;

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
3390: INTO l_sub_opt_id
3391: FROM dual;

Line 3391: FROM dual;

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
3394: (regime_usage_id,
3395: first_pty_org_id,

Line 3657: FROM DUAL;

3653: 'JE.HU.ARXSUVAT.TAX_ORIGIN', p_global_attribute1,
3654: 'JE.PL.ARXSUVAT.TAX_ORIGIN', p_global_attribute1,
3655: Zx_Migrate_Util.GET_TAX( p_tax_code, p_tax_type) )
3656: INTO l_tax
3657: FROM DUAL;
3658:
3659: Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
3660: Zx_Migrate_Tax_Default_Hier.create_process_results
3661: (p_tax_id => p_vat_tax_id,