DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_TAXES_VL

Line 4526: FROM zx_taxes_vl ztvl,

4522: AND tax_name IS NOT NULL
4523: AND NOT EXISTS
4524: (
4525: SELECT 1
4526: FROM zx_taxes_vl ztvl,
4527: zx_subscription_details sd
4528: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4529: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4530: AND (sd.view_options_code in ('NONE', 'VFC')

Line 4563: FROM zx_taxes_vl ztvl,

4559: -- value to id conversion for tax
4560: UPDATE zx_exemptions_int exe_int
4561: SET tax_code = (
4562: SELECT ztvl.tax
4563: FROM zx_taxes_vl ztvl,
4564: zx_subscription_details sd
4565: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4566: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4567: AND (sd.view_options_code in ('NONE', 'VFC')