DBA Data[Home] [Help]

VIEW: APPS.PA_OUTPUT_TAX_CODE_SETUP_V

Source

View Text - Preformatted

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))