APPS.JTF_IH_CORE_UTIL_PVT dependencies on CS_LOOKUPS

Line 175: FROM cs_lookups

171: BEGIN
172: x_return_status := fnd_api.g_ret_sts_success;
173:
174: SELECT lookup_code INTO x_lookup_code
175: FROM cs_lookups
176: WHERE lookup_type = p_lookup_type
177: AND meaning = p_meaning;
178: EXCEPTION
179: WHEN no_data_found THEN

Line 419: FROM cs_lookups

415: BEGIN
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: SELECT 'x' INTO l_dummy
419: FROM cs_lookups
420: WHERE lookup_code = p_lookup_code
421: AND lookup_type = p_lookup_type
422: AND enabled_flag = 'Y'
423: AND Trunc(Sysdate) BETWEEN Trunc(Nvl(start_date_active, Sysdate))