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;