DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_RATES_B

Line 4790: FROM zx_rates_b zrvl, zx_subscription_details sd

4786: WHERE (( tax_rate_code IS NOT NULL
4787: AND NOT EXISTS
4788: (
4789: SELECT 1
4790: FROM zx_rates_b zrvl, zx_subscription_details sd
4791: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4792: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4793: AND (sd.view_options_code in ('NONE', 'VFC')
4794: or

Line 4797: FROM zx_rates_b b

4793: AND (sd.view_options_code in ('NONE', 'VFC')
4794: or
4795: (sd.view_options_code = 'VFR'
4796: AND not exists ( SELECT 1
4797: FROM zx_rates_b b
4798: WHERE b.tax_regime_code = zrvl.tax_regime_code
4799: AND b.tax = zrvl.tax
4800: AND b.tax_status_code = zrvl.tax_status_code
4801: AND b.tax_rate_code = zrvl.tax_rate_code

Line 4826: FROM zx_rates_b b

4822: AND (sd.view_options_code in ('NONE', 'VFC')
4823: or
4824: (sd.view_options_code = 'VFR'
4825: AND not exists ( SELECT 1
4826: FROM zx_rates_b b
4827: WHERE b.tax_regime_code = zrvl.tax_regime_code
4828: AND b.tax = zrvl.tax
4829: AND b.tax_status_code = zrvl.tax_status_code
4830: AND b.tax_rate_code = zrvl.tax_rate_code

Line 4866: FROM zx_rates_b b

4862: AND (sd.view_options_code in ('NONE', 'VFC')
4863: or
4864: (sd.view_options_code = 'VFR'
4865: AND not exists ( SELECT 1
4866: FROM zx_rates_b b
4867: WHERE b.tax_regime_code = zrvl.tax_regime_code
4868: AND b.tax = zrvl.tax
4869: AND b.tax_status_code = zrvl.tax_status_code
4870: AND b.tax_rate_code = zrvl.tax_rate_code