APPS.ZX_PTP_IMPORT dependencies on ZX_TAXES_B

Line 3655: from zx_taxes_b tax

3651: AND BITAND(reg_int.error_number,G_ES_REG_TAX_PARAM_INVALID) = 0
3652: and reg_int.tax_code IS NOT NULL
3653: AND EXISTS (
3654: select 1
3655: from zx_taxes_b tax
3656: where tax.tax = reg_int.tax_code
3657: and tax.tax_regime_code = reg_int.tax_regime_code
3658: and nvl(allow_dup_regn_num_flag,'N') = 'Y'
3659: );

Line 4498: FROM zx_taxes_b ztvl,

4494: WHERE (( tax_code IS NOT NULL
4495: AND NOT EXISTS
4496: (
4497: SELECT 1
4498: FROM zx_taxes_b ztvl,
4499: zx_subscription_details sd
4500: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4501: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4502: AND (sd.view_options_code in ('NONE', 'VFC')

Line 4506: FROM zx_taxes_b b

4502: AND (sd.view_options_code in ('NONE', 'VFC')
4503: or
4504: (sd.view_options_code = 'VFR'
4505: AND not exists ( SELECT 1
4506: FROM zx_taxes_b b
4507: WHERE b.tax_regime_code = ztvl.tax_regime_code
4508: AND b.tax = ztvl.tax
4509: AND b.content_owner_id = sd.first_pty_org_id
4510: )

Line 4534: FROM zx_taxes_b b

4530: AND (sd.view_options_code in ('NONE', 'VFC')
4531: or
4532: (sd.view_options_code = 'VFR'
4533: AND not exists ( SELECT 1
4534: FROM zx_taxes_b b
4535: WHERE b.tax_regime_code = ztvl.tax_regime_code
4536: AND b.tax = ztvl.tax
4537: AND b.content_owner_id = sd.first_pty_org_id
4538: )

Line 4571: FROM zx_taxes_b b

4567: AND (sd.view_options_code in ('NONE', 'VFC')
4568: or
4569: (sd.view_options_code = 'VFR'
4570: AND not exists ( SELECT 1
4571: FROM zx_taxes_b b
4572: WHERE b.tax_regime_code = ztvl.tax_regime_code
4573: AND b.tax = ztvl.tax
4574: AND b.content_owner_id = sd.first_pty_org_id
4575: )