DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on IEX_LOOKUPS_V

Line 453: from iex_lookups_v

449:
450:
451: select count(lookup_code)
452: into count_id
453: from iex_lookups_v
454: where lookup_type = p_lookup_type
455: and lookup_code = p_lookup_code
456: and enabled_flag = 'Y';
457:

Line 1313: l_meaning iex_lookups_v.meaning%TYPE;

1309: -- Begin- Andre 09/15/2004 - Function to get lookup meaning - performance enhancement as per Ramakant Alat
1310: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
1311: p_lookup_code IN VARCHAR2)
1312: RETURN VARCHAR2 IS
1313: l_meaning iex_lookups_v.meaning%TYPE;
1314: l_hash_value NUMBER;
1315: BEGIN
1316: IF p_lookup_code IS NOT NULL AND
1317: p_lookup_type IS NOT NULL THEN

Line 1330: FROM iex_lookups_v

1326: ELSE
1327:
1328: SELECT meaning
1329: INTO l_meaning
1330: FROM iex_lookups_v
1331: WHERE lookup_type = p_lookup_type
1332: AND lookup_code = p_lookup_code ;
1333:
1334: pg_lookups_rec(l_hash_value) := l_meaning;