DBA Data[Home] [Help]

APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_RATES_TL

Line 3670: -- 6820043: moving description from zx_rates_b to zx_rates_tl

3666: ELSIF p_dml_type = 'U' THEN
3667:
3668: arp_util_tax.debug('p_dml_type'||p_dml_type);
3669:
3670: -- 6820043: moving description from zx_rates_b to zx_rates_tl
3671: UPDATE ZX_RATES_B_TMP
3672: SET EFFECTIVE_TO = P_END_DATE,
3673: ACTIVE_FLAG = P_ENABLED_FLAG,
3674: ADJ_FOR_ADHOC_AMT_CODE = DECODE(nvl(P_VALIDATE_FLAG, 'N'),'Y', 'RATES','N', NULL),

Line 3702: UPDATE ZX_RATES_TL

3698: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
3699: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
3700: WHERE TAX_RATE_ID = P_VAT_TAX_ID;
3701:
3702: UPDATE ZX_RATES_TL
3703: SET TAX_RATE_NAME = P_PRINTED_TAX_NAME,
3704: DESCRIPTION = P_DESCRIPTION,
3705: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3706: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,