APPS.ZX_VALIDATE_API_PKG dependencies on ZX_JURISDICTIONS_B

Line 1014: FROM ZX_JURISDICTIONS_B Jur,

1010:
1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1012: SET tax_jurisdiction_code =
1013: (SELECT jur.TAX_JURISDICTION_CODE
1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,
1016: ZX_TRANSACTION_LINES_GT Lines,
1017: ZX_RATES_B rates,
1018: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 1684: ZX_JURISDICTIONS_B jur,

1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1688: -- zx_subscription_details sd_rates

Line 1707: FROM ZX_JURISDICTIONS_B

1703: /*OR jur.effective_from =
1704: (
1705: SELECT
1706: min(effective_from)
1707: FROM ZX_JURISDICTIONS_B
1708: WHERE tax_jurisdiction_code = jur.tax_jurisdiction_code
1709: ) */
1710: )
1711: AND lines_gt.application_id = header.application_id

Line 5404: ZX_JURISDICTIONS_B jur,

5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5408: -- zx_subscription_details sd_rates

Line 5431: FROM ZX_JURISDICTIONS_B

5427: /*OR jur.effective_from =
5428: (
5429: SELECT
5430: min(effective_from)
5431: FROM ZX_JURISDICTIONS_B
5432: WHERE tax_jurisdiction_code = jur.tax_jurisdiction_code
5433: ) */
5434: )
5435: AND lines_gt.application_id = header.application_id