DBA Data[Home] [Help]

APPS.PAY_KW_PAYROLL_REGISTER dependencies on HR_LOOKUPS

Line 2032: from hr_lookups

2028: ,p_lookup_code varchar2)
2029: RETURN VARCHAR2 IS
2030: CURSOR csr_lookup IS
2031: select meaning
2032: from hr_lookups
2033: where lookup_type = p_lookup_type
2034: and lookup_code = p_lookup_code;
2035: l_meaning hr_lookups.meaning%type;
2036: BEGIN

Line 2035: l_meaning hr_lookups.meaning%type;

2031: select meaning
2032: from hr_lookups
2033: where lookup_type = p_lookup_type
2034: and lookup_code = p_lookup_code;
2035: l_meaning hr_lookups.meaning%type;
2036: BEGIN
2037: OPEN csr_lookup;
2038: FETCH csr_lookup INTO l_Meaning;
2039: CLOSE csr_lookup;