DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_LOOKUPS

Line 184: RETURN cn_lookups.meaning%TYPE IS

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

Line 186: l_meaning cn_lookups.meaning%TYPE;

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

Line 191: FROM cn_lookups

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: