DBA Data[Home] [Help]

APPS.PAY_CA_T4_REG dependencies on HR_LOOKUPS

Line 690: l_meaning hr_lookups.meaning%TYPE;

686: --
687: function get_label(p_lookup_type in varchar2,
688: p_lookup_code in varchar2) return varchar2 is
689:
690: l_meaning hr_lookups.meaning%TYPE;
691:
692: CURSOR cur_get_meaning IS
693: SELECT hl.meaning
694: FROM hr_lookups hl

Line 694: FROM hr_lookups hl

690: l_meaning hr_lookups.meaning%TYPE;
691:
692: CURSOR cur_get_meaning IS
693: SELECT hl.meaning
694: FROM hr_lookups hl
695: WHERE hl.lookup_type = p_lookup_type AND
696: hl.lookup_code = p_lookup_code;
697:
698: BEGIN