DBA Data[Home] [Help]

APPS.PV_SQL_UTILITY dependencies on FND_LOOKUP_VALUES

Line 114: --| fnd_lookup_values |

110:
111:
112: --=============================================================================+
113: --| Public Procedure |
114: --| fnd_lookup_values |
115: --| |
116: --| Parameters |
117: --| IN |
118: --| OUT |

Line 126: FUNCTION fnd_lookup_values (

122: --| |
123: --| HISTORY |
124: --| |
125: --==============================================================================
126: FUNCTION fnd_lookup_values (
127: p_lookup_code IN VARCHAR2,
128: p_lookup_type IN VARCHAR2
129: )
130: RETURN VARCHAR2

Line 136: FROM fnd_lookup_values

132: l_meaning VARCHAR2(80);
133:
134: BEGIN
135: FOR x IN (SELECT meaning
136: FROM fnd_lookup_values
137: WHERE lookup_code = p_lookup_code AND
138: lookup_type = p_lookup_type AND
139: LANGUAGE(+) = USERENV('LANG'))
140: LOOP

Line 146: END fnd_lookup_values;

142: END LOOP;
143:
144: RETURN l_meaning;
145:
146: END fnd_lookup_values;
147:
148:
149: --=============================================================================+
150: --| Public Procedure |