1010: ---------------------------------------------------------------------
1011: -- NAME : lookup_meaning --
1012: -- Type : Private Procedure --
1013: -- DESCRIPTION : --
1014: -- Function returns the MEANING column from HR_LOOKUPS for the --
1015: -- specified LOOKUP_TYPE and LOOKUP_CODE --
1016: ---------------------------------------------------------------------
1017: FUNCTION lookup_meaning(p_lookup_type in varchar2,
1018: p_lookup_code in varchar2) return VARCHAR2
1016: ---------------------------------------------------------------------
1017: FUNCTION lookup_meaning(p_lookup_type in varchar2,
1018: p_lookup_code in varchar2) return VARCHAR2
1019: IS
1020: l_meaning hr_lookups.meaning%type := null;
1021: cursor c_lookup is
1022: select lku.meaning
1023: from hr_lookups lku
1024: where lku.lookup_type = p_lookup_type
1019: IS
1020: l_meaning hr_lookups.meaning%type := null;
1021: cursor c_lookup is
1022: select lku.meaning
1023: from hr_lookups lku
1024: where lku.lookup_type = p_lookup_type
1025: and lku.lookup_code = p_lookup_code;
1026: BEGIN
1027: open c_lookup;