DBA Data[Home] [Help]

APPS.PYUDET dependencies on HR_LOOKUPS

Line 1140: -- Function returns the MEANING column from HR_LOOKUPS for the --

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

Line 1146: l_meaning hr_lookups.meaning%type := null;

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

Line 1149: from hr_lookups lku

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;