1136: ---------------------------------------------------------------------
1137: -- NAME : lookup_meaning --
1138: -- Type : Private Procedure --
1139: -- DESCRIPTION : --
1140: -- Function returns the MEANING column from HR_LOOKUPS for the --
1141: -- specified LOOKUP_TYPE and LOOKUP_CODE --
1142: ---------------------------------------------------------------------
1143: FUNCTION lookup_meaning(p_lookup_type in varchar2,
1144: p_lookup_code in varchar2) return VARCHAR2
1142: ---------------------------------------------------------------------
1143: FUNCTION lookup_meaning(p_lookup_type in varchar2,
1144: p_lookup_code in varchar2) return VARCHAR2
1145: IS
1146: l_meaning hr_lookups.meaning%type := null;
1147: cursor c_lookup is
1148: select lku.meaning
1149: from hr_lookups lku
1150: where lku.lookup_type = p_lookup_type
1145: IS
1146: l_meaning hr_lookups.meaning%type := null;
1147: cursor c_lookup is
1148: select lku.meaning
1149: from hr_lookups lku
1150: where lku.lookup_type = p_lookup_type
1151: and lku.lookup_code = p_lookup_code;
1152: BEGIN
1153: open c_lookup;