DBA Data[Home] [Help]

APPS.CN_API dependencies on CN_LOOKUPS

Line 206: RETURN cn_lookups.meaning%TYPE IS

202: --| Function Name : get_lkup_meaning
203: --| ---------------------------------------------------------------------+
204: FUNCTION get_lkup_meaning( p_lkup_code VARCHAR2,
205: p_lkup_type VARCHAR2 )
206: RETURN cn_lookups.meaning%TYPE IS
207:
208: l_meaning cn_lookups.meaning%TYPE;
209:
210: BEGIN

Line 208: l_meaning cn_lookups.meaning%TYPE;

204: FUNCTION get_lkup_meaning( p_lkup_code VARCHAR2,
205: p_lkup_type VARCHAR2 )
206: RETURN cn_lookups.meaning%TYPE IS
207:
208: l_meaning cn_lookups.meaning%TYPE;
209:
210: BEGIN
211: SELECT meaning
212: INTO l_meaning

Line 213: FROM cn_lookups

209:
210: BEGIN
211: SELECT meaning
212: INTO l_meaning
213: FROM cn_lookups
214: WHERE lookup_type = p_lkup_type
215: AND lookup_code = p_lkup_code
216: ;
217: