DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_RATES_VL

Line 4819: FROM zx_rates_vl zrvl, zx_subscription_details sd

4815: AND tax_rate_name IS NOT NULL
4816: AND NOT EXISTS
4817: (
4818: SELECT 1
4819: FROM zx_rates_vl zrvl, zx_subscription_details sd
4820: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4821: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4822: AND (sd.view_options_code in ('NONE', 'VFC')
4823: or

Line 4859: FROM zx_rates_vl zrvl, zx_subscription_details sd

4855: -- value to id conversion for tax_rate_code
4856: UPDATE zx_exemptions_int exe_int
4857: SET TAX_RATE_CODE = (
4858: SELECT zrvl.tax_rate_code
4859: FROM zx_rates_vl zrvl, zx_subscription_details sd
4860: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4861: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4862: AND (sd.view_options_code in ('NONE', 'VFC')
4863: or