1641: END IF;
1642:
1643: SELECT 'VALID'
1644: INTO l_dummy
1645: FROM fnd_lookups
1646: WHERE LOOKUP_CODE = p_tax_exempt_flag
1647: AND LOOKUP_TYPE = l_lookup_type
1648: AND ENABLED_FLAG = 'Y'
1649: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1758: END IF;
1759:
1760: SELECT 'VALID'
1761: INTO l_dummy
1762: FROM fnd_lookups
1763: WHERE LOOKUP_CODE = p_tax_exempt_reason_code
1764: AND LOOKUP_TYPE = l_lookup_type
1765: AND ENABLED_FLAG = 'Y'
1766: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)