DBA Data[Home] [Help]

APPS.PYUDET dependencies on HR_LOOKUPS

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

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

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

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

Line 1023: from hr_lookups lku

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;