APPS.ZX_VALIDATE_API_PKG dependencies on ZX_JURISDICTIONS_B

Line 1344: FROM ZX_JURISDICTIONS_B Jur,

1340:
1341: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1342: SET tax_jurisdiction_code =
1343: (SELECT jur.TAX_JURISDICTION_CODE
1344: FROM ZX_JURISDICTIONS_B Jur,
1345: ZX_TRX_HEADERS_GT Header,
1346: --ZX_TRANSACTION_LINES_GT Lines,
1347: ZX_RATES_B rates,
1348: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 2022: ZX_JURISDICTIONS_B jur,

2018: -- zx_rates_b off_rate,
2019: -- zx_import_tax_lines_gt temp_gt,
2020: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2021: zx_transaction_lines_gt lines_gt,
2022: ZX_JURISDICTIONS_B jur,
2023: zx_subscription_details sd_reg,
2024: zx_subscription_details sd_tax,
2025: zx_subscription_details sd_status
2026: -- zx_subscription_details sd_rates

Line 2044: FROM ZX_JURISDICTIONS_B

2040: /*OR jur.effective_from =
2041: (
2042: SELECT
2043: min(effective_from)
2044: FROM ZX_JURISDICTIONS_B
2045: WHERE tax_jurisdiction_code = jur.tax_jurisdiction_code
2046: ) */
2047: )
2048: AND lines_gt.application_id = header.application_id

Line 5431: ZX_JURISDICTIONS_B jur,

5427: -- zx_rates_b off_rate,
5428: -- zx_import_tax_lines_gt temp_gt,
5429: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5430: --zx_transaction_lines_gt lines_gt,
5431: ZX_JURISDICTIONS_B jur,
5432: zx_subscription_details sd_reg,
5433: zx_subscription_details sd_tax,
5434: zx_subscription_details sd_status
5435: -- zx_subscription_details sd_rates

Line 5453: FROM ZX_JURISDICTIONS_B

5449: /*OR jur.effective_from =
5450: (
5451: SELECT
5452: min(effective_from)
5453: FROM ZX_JURISDICTIONS_B
5454: WHERE tax_jurisdiction_code = jur.tax_jurisdiction_code
5455: ) */
5456: -- )
5457: --AND lines_gt.application_id = header.application_id