[Home] [Help]
59: cursor cur_lookup_values(c_lookup_type in varchar2
60: , c_lookup_code in varchar2) is
61: select t.meaning
62: from fnd_lookup_values t
63: , fnd_lookup_types l
64: where l.lookup_type = c_lookup_type
65: and t.lookup_code = c_lookup_code
66: and l.lookup_type = t.lookup_type
67: and l.security_group_id = t.security_group_id
268:
269: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'
270: , n_appid in number) is
271: select count(c.application_id) id_count
272: from fnd_lookup_types c
273: where c.application_id = n_appid
274: and c.lookup_type like c_name ESCAPE '\';
275:
276: cursor cur_event(c_name in dba_objects.object_name%type := '%'
516: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'
517: , n_appid in number) is
518: select v.lookup_type id
519: , v.lookup_type name
520: from fnd_lookup_types v
521: where v.application_id = n_appid
522: and v.lookup_type like c_name ESCAPE '\'
523: order by lookup_type;
524:
1407: cursor cur_lookup_tl(c_lookup_type in varchar2
1408: , n_appid in number) is
1409: select t.meaning
1410: , t.description
1411: from fnd_lookup_types_tl t
1412: , fnd_lookup_types l
1413: where l.application_id = n_appid
1414: and l.lookup_type = c_lookup_type
1415: and l.lookup_type = t.lookup_type
1408: , n_appid in number) is
1409: select t.meaning
1410: , t.description
1411: from fnd_lookup_types_tl t
1412: , fnd_lookup_types l
1413: where l.application_id = n_appid
1414: and l.lookup_type = c_lookup_type
1415: and l.lookup_type = t.lookup_type
1416: and t.language = userenv('LANG');
1421: select t.lookup_code
1422: , t.meaning
1423: , t.description
1424: from fnd_lookup_values t
1425: , fnd_lookup_types l
1426: where l.application_id = n_appid
1427: and l.lookup_type = c_lookup_type
1428: and l.lookup_type = t.lookup_type
1429: and l.security_group_id = t.security_group_id