DBA Data[Home] [Help]

APPS.JTF_TTY_GEOSOURCE_PUB dependencies on FND_LOOKUPS

Line 54: FROM fnd_lookups

50: p_date := sysdate;
51: BEGIN
52: SELECT 'Y'
53: into p_geo_type_exists_flag
54: FROM fnd_lookups
55: WHERE lookup_type = 'JTF_TTY_GEO_TYPE'
56: AND lookup_code = p_geo_type
57: AND ROWNUM < 2;
58: EXCEPTION

Line 430: FROM fnd_lookups

426: END;
427: BEGIN
428: SELECT 'Y'
429: into p_geo_type_exists_flag
430: FROM fnd_lookups
431: WHERE lookup_type = 'JTF_TTY_GEO_TYPE'
432: AND lookup_code = p_geo_type
433: AND ROWNUM < 2;
434: EXCEPTION