DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_TAXES_B

Line 2147: ZX_TAXES_B tax,

2143:
2144: FROM
2145: ZX_TRX_HEADERS_GT header,
2146: ZX_REGIMES_B regime,
2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,

Line 2196: from zx_taxes_b

2192: nvl(tax.effective_from,header.trx_date) AND
2193: nvl(tax.effective_to, header.trx_date)
2194: OR
2195: tax.effective_from = (select min(effective_from)
2196: from zx_taxes_b
2197: where tax = tax.tax)
2198: )
2199: AND (header.trx_date between
2200: nvl(sd_tax.effective_from,header.trx_date) AND

Line 2208: FROM zx_taxes_b b

2204: or
2205: ( nvl(sd_tax.view_options_code,'VFR') = 'VFR'
2206: AND not exists
2207: ( SELECT 1
2208: FROM zx_taxes_b b
2209: WHERE tax.tax_regime_code = b.tax_regime_code
2210: AND tax.tax = b.tax
2211: AND sd_tax.first_pty_org_id = b.content_owner_id )
2212: )

Line 2624: FROM zx_taxes_b taxes

2620: CASE
2621: WHEN EXISTS
2622: (
2623: SELECT 1
2624: FROM zx_taxes_b taxes
2625: WHERE taxes.tax_regime_code = taxlines_gt.tax_regime_code
2626: AND taxes.tax = taxlines_gt.tax
2627: AND taxes.def_inclusive_tax_flag <> taxlines_gt.tax_amt_included_flag
2628: AND taxes.tax_inclusive_override_flag = 'N'