DBA Data[Home] [Help]

APPS.OE_VALIDATE dependencies on FND_LOOKUPS

Line 1645: FROM fnd_lookups

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)

Line 1762: FROM fnd_lookups

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)