DBA Data[Home] [Help]

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;