DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_LOOKUPS

Line 1479: from hr_lookups

1475: FUNCTION get_lookup_meaning (p_lookup_type IN varchar2,p_lookup_code IN varchar2) RETURN VARCHAR2 IS
1476:
1477: CURSOR csr_lookup IS
1478: select meaning
1479: from hr_lookups
1480: where lookup_type = p_lookup_type
1481: and lookup_code = p_lookup_code
1482: and enabled_flag = 'Y';
1483:

Line 1484: l_meaning hr_lookups.meaning%type;

1480: where lookup_type = p_lookup_type
1481: and lookup_code = p_lookup_code
1482: and enabled_flag = 'Y';
1483:
1484: l_meaning hr_lookups.meaning%type;
1485:
1486: BEGIN
1487:
1488: OPEN csr_lookup;