DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_STATUS_B

Line 2148: ZX_STATUS_B status,

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,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,

Line 2227: from zx_status_b

2223: nvl(status.effective_from,header.trx_date) AND
2224: nvl(status.effective_to, header.trx_date)
2225: OR
2226: status.effective_from = (select min(effective_from)
2227: from zx_status_b
2228: where tax_status_code =
2229: status.tax_status_code)
2230: )
2231: AND (header.trx_date between