APPS.ZX_VALIDATE_API_PKG dependencies on ZX_TAXES_B

Line 1416: ZX_TAXES_B tax,

1412: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1413: ZX_IMPORT_TAX_LINES_GT TaxLines,
1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,
1419: zx_subscription_details sd_rates
1420: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'

Line 1500: FROM ZX_TAXES_B

1496: header.trx_date,
1497: SYSDATE) )
1498: OR
1499: tax.effective_from = (SELECT MIN(effective_from)
1500: FROM ZX_TAXES_B
1501: WHERE
1502: tax_regime_code = tax.tax_regime_code and
1503: tax = tax.tax and
1504: content_owner_id = tax.content_owner_id

Line 1509: AND NOT EXISTS (SELECT 1 FROM zx_taxes_b b

1505: )
1506: )
1507: and (nvl(sd_tax.view_options_code,'NONE') in ('NONE', 'VFC') OR
1508: (nvl(sd_tax.view_options_code,'VFR') = 'VFR'
1509: AND NOT EXISTS (SELECT 1 FROM zx_taxes_b b
1510: WHERE tax.tax_regime_code = b.tax_regime_code
1511: AND tax.tax = b.tax
1512: AND sd_tax.first_pty_org_id = b.content_owner_id
1513: )

Line 1677: ZX_TAXES_B tax ,

1673: lines_gt.trx_level_type,
1674: taxlines_gt.summary_tax_line_number
1675: FROM ZX_TRX_HEADERS_GT header,
1676: ZX_REGIMES_B regime ,
1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,

Line 1802: FROM ZX_TAXES_B

1798: /*OR tax.effective_from =
1799: (
1800: SELECT
1801: min(effective_from)
1802: FROM ZX_TAXES_B
1803: WHERE tax_regime_code = tax.tax_regime_code
1804: AND tax = tax.tax
1805: AND content_owner_id = tax.content_owner_id
1806: ) */

Line 1818: FROM zx_taxes_b b

1814: AND not exists
1815: (
1816: SELECT
1817: 1
1818: FROM zx_taxes_b b
1819: WHERE tax.tax_regime_code = b.tax_regime_code
1820: AND tax.tax = b.tax
1821: AND sd_tax.first_pty_org_id = b.content_owner_id
1822: )

Line 4056: AND (EXISTS (SELECT 1 FROM ZX_TAXES_B

4052:
4053: --Commented for Bug#7504455--
4054: /*CASE WHEN /*(lines_gt.output_tax_classification_code IS NOT NULL OR
4055: lines_gt.input_tax_classification_code IS NOT NULL)
4056: AND (EXISTS (SELECT 1 FROM ZX_TAXES_B
4057: WHERE TAX_TYPE_CODE = 'OFFSET'
4058: AND tax IN (SELECT tax FROM ZX_RATES_B
4059: WHERE tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4060: lines_gt.input_tax_classification_code)))

Line 5397: ZX_TAXES_B tax ,

5393:
5394: /* end bug 3676878 */
5395: FROM ZX_TRX_HEADERS_GT header,
5396: ZX_REGIMES_B regime ,
5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,

Line 5526: FROM ZX_TAXES_B

5522: /*OR tax.effective_from =
5523: (
5524: SELECT
5525: min(effective_from)
5526: FROM ZX_TAXES_B
5527: WHERE tax_regime_code = tax.tax_regime_code
5528: AND tax = tax.tax
5529: AND content_owner_id = tax.content_owner_id
5530: ) */

Line 5542: FROM zx_taxes_b b

5538: AND not exists
5539: (
5540: SELECT
5541: 1
5542: FROM zx_taxes_b b
5543: WHERE tax.tax_regime_code = b.tax_regime_code
5544: AND tax.tax = b.tax
5545: AND sd_tax.first_pty_org_id = b.content_owner_id
5546: )

Line 5772: ZX_TAXES_B tax ,

5768: zx_trx_headers_gt header,
5769: zx_transaction_lines_gt lines_gt,
5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5771: ZX_REGIMES_B regime ,
5772: ZX_TAXES_B tax ,
5773: ZX_STATUS_B status ,
5774: zx_subscription_details sd_reg,
5775: zx_subscription_details sd_tax,
5776: zx_subscription_details sd_status

Line 5849: FROM zx_taxes_b b

5845: AND not exists
5846: (
5847: SELECT
5848: 1
5849: FROM zx_taxes_b b
5850: WHERE tax.tax_regime_code = b.tax_regime_code
5851: AND tax.tax = b.tax
5852: AND sd_tax.first_pty_org_id = b.content_owner_id
5853: )