180: --| Function Name : get_lkup_meaning
181: --| ---------------------------------------------------------------------+
182: FUNCTION get_lkup_meaning( p_lkup_code VARCHAR2,
183: p_lkup_type VARCHAR2 )
184: RETURN cn_lookups.meaning%TYPE IS
185:
186: l_meaning cn_lookups.meaning%TYPE;
187:
188: BEGIN
182: FUNCTION get_lkup_meaning( p_lkup_code VARCHAR2,
183: p_lkup_type VARCHAR2 )
184: RETURN cn_lookups.meaning%TYPE IS
185:
186: l_meaning cn_lookups.meaning%TYPE;
187:
188: BEGIN
189: SELECT meaning
190: INTO l_meaning
187:
188: BEGIN
189: SELECT meaning
190: INTO l_meaning
191: FROM cn_lookups
192: WHERE lookup_type = p_lkup_type
193: AND lookup_code = p_lkup_code
194: ;
195: