DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on IEX_LOOKUPS_V

Line 562: from iex_lookups_v

558:
559:
560: select count(lookup_code)
561: into count_id
562: from iex_lookups_v
563: where lookup_type = p_lookup_type
564: and lookup_code = p_lookup_code
565: and enabled_flag = 'Y';
566:

Line 1422: l_meaning iex_lookups_v.meaning%TYPE;

1418: -- Begin- Andre 09/15/2004 - Function to get lookup meaning - performance enhancement as per Ramakant Alat
1419: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
1420: p_lookup_code IN VARCHAR2)
1421: RETURN VARCHAR2 IS
1422: l_meaning iex_lookups_v.meaning%TYPE;
1423: l_hash_value NUMBER;
1424: BEGIN
1425: IF p_lookup_code IS NOT NULL AND
1426: p_lookup_type IS NOT NULL THEN

Line 1439: FROM iex_lookups_v

1435: ELSE
1436:
1437: SELECT meaning
1438: INTO l_meaning
1439: FROM iex_lookups_v
1440: WHERE lookup_type = p_lookup_type
1441: AND lookup_code = p_lookup_code ;
1442:
1443: pg_lookups_rec(l_hash_value) := l_meaning;