DBA Data[Home] [Help]

APPS.JG_ZZ_SHARED_PKG dependencies on FND_LOOKUPS

Line 14: SELECT 'Yes' into l_disabled FROM FND_LOOKUPS

10: l_country_code := p_country_code;
11:
12: IF l_country_code IS NOT NULL THEN
13: BEGIN
14: SELECT 'Yes' into l_disabled FROM FND_LOOKUPS
15: WHERE LOOKUP_TYPE = 'JG_DISABLE_GLOBALIZATION'
16: AND ENABLED_FLAG = 'Y'
17: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE+1)) >= TRUNC(SYSDATE)
18: AND TRUNC(START_DATE_ACTIVE) <= TRUNC(SYSDATE)