DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_JURISDICTIONS_B

Line 485: FROM zx_jurisdictions_b

481: IF l_tax_exmpt_source_tax IS NOT NULL THEN
482: IF p_tax_jurisdiction_id IS NOT NULL THEN
483: SELECT TAX_EXMPT_SRC_JURISDICT_ID
484: INTO l_source_tax_jurisdiction_id
485: FROM zx_jurisdictions_b
486: WHERE tax_jurisdiction_id = p_tax_jurisdiction_id
487: AND effective_from <= p_tax_date
488: AND (effective_to >= p_tax_date or effective_to is null);
489: END IF;