DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on HR_LOOKUPS

Line 1571: from hr_lookups

1567: -- function to get labels of items from a lookup
1568: FUNCTION get_lookup_meaning (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
1569: CURSOR csr_lookup IS
1570: select meaning
1571: from hr_lookups
1572: where lookup_type = p_lookup_type
1573: and lookup_code = p_lookup_code;
1574: l_meaning hr_lookups.meaning%type;
1575: BEGIN

Line 1574: l_meaning hr_lookups.meaning%type;

1570: select meaning
1571: from hr_lookups
1572: where lookup_type = p_lookup_type
1573: and lookup_code = p_lookup_code;
1574: l_meaning hr_lookups.meaning%type;
1575: BEGIN
1576: OPEN csr_lookup;
1577: FETCH csr_lookup INTO l_Meaning;
1578: CLOSE csr_lookup;