DBA Data[Home] [Help]

APPS.CS_CORE_UTIL dependencies on CS_LOOKUPS

Line 330: FROM cs_lookups

326: BEGIN
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: SELECT lookup_code INTO x_lookup_code
330: FROM cs_lookups
331: WHERE lookup_type = p_lookup_type
332: AND meaning = p_meaning;
333: EXCEPTION
334: WHEN no_data_found THEN

Line 1133: FROM cs_lookups

1129: BEGIN
1130: x_return_status := fnd_api.g_ret_sts_success;
1131:
1132: SELECT 'x' INTO l_dummy
1133: FROM cs_lookups
1134: WHERE lookup_code = p_lookup_code
1135: AND lookup_type = p_lookup_type
1136: AND enabled_flag = 'Y'
1137: AND Trunc(Sysdate) BETWEEN Trunc(Nvl(start_date_active, Sysdate))