SELECT DISTINCT tax_name , tax_code , org_id FROM PA_OUTPUT_TAX_CODE_TXN_V WHERE trunc(SYSDATE) BETWEEN trunc(nvl(START_DATE_Active, sysdate)) AND trunc(NVL(END_DATE_ACTIVE,SYSDATE))
View Text - HTML Formatted
SELECT DISTINCT TAX_NAME , TAX_CODE , ORG_ID FROM PA_OUTPUT_TAX_CODE_TXN_V WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE , SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE , SYSDATE))