DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_TAXES_B

Line 1944: ZX_TAXES_B tax ,

1940: FROM
1941: ZX_TRX_HEADERS_GT header,
1942: ZX_EVNT_CLS_MAPPINGS evntmap,
1943: ZX_REGIMES_B regime ,
1944: ZX_TAXES_B tax ,
1945: ZX_STATUS_B status ,
1946: AR_VAT_TAX_ALL_B rate ,
1947: -- zx_import_tax_lines_gt temp_gt,
1948: ZX_TRANSACTION_LINES_GT lines_gt,

Line 1978: from ZX_TAXES_B

1974: nvl(tax.effective_from,header.trx_date) AND
1975: nvl(tax.effective_to, header.trx_date)
1976: OR
1977: tax.effective_from = (select min(effective_from)
1978: from ZX_TAXES_B
1979: where tax = tax.tax)
1980: )
1981: and status.tax_status_code(+)= taxlines_gt.tax_status_code
1982: and (header.trx_date BETWEEN

Line 2185: FROM zx_taxes_b taxes

2181: CASE
2182: WHEN EXISTS
2183: (
2184: SELECT 1
2185: FROM zx_taxes_b taxes
2186: WHERE taxes.tax_regime_code = imptaxes_gt.tax_regime_code
2187: AND taxes.tax = imptaxes_gt.tax
2188: AND taxes.def_inclusive_tax_flag <> imptaxes_gt.tax_amt_included_flag
2189: AND taxes.tax_inclusive_override_flag = 'N'