APPS.ZX_TCM_GET_EXEMPT_PKG dependencies on ZX_JURISDICTIONS_B
Line 234: FROM zx_jurisdictions_b
230: IF l_tax_exmpt_source_tax IS NOT NULL THEN
231: IF p_tax_jurisdiction_id IS NOT NULL THEN
232: SELECT TAX_EXMPT_SRC_JURISDICT_ID
233: INTO l_source_tax_jurisdiction_id 234: FROM zx_jurisdictions_b 235: WHERE tax_jurisdiction_id = p_tax_jurisdiction_id
236: AND effective_from <= p_tax_date
237: AND (effective_to >= p_tax_date or effective_to is null);
238: END IF;