DBA Data[Home] [Help]

APPS.PAY_KW_CHEQUE_REPORT dependencies on HR_LOOKUPS

Line 27: from hr_lookups

23: ,p_lookup_code varchar2)
24: RETURN VARCHAR2 IS
25: CURSOR csr_lookup IS
26: select meaning
27: from hr_lookups
28: where lookup_type = p_lookup_type
29: and lookup_code = p_lookup_code;
30: l_meaning hr_lookups.meaning%type;
31: BEGIN

Line 30: l_meaning hr_lookups.meaning%type;

26: select meaning
27: from hr_lookups
28: where lookup_type = p_lookup_type
29: and lookup_code = p_lookup_code;
30: l_meaning hr_lookups.meaning%type;
31: BEGIN
32: OPEN csr_lookup;
33: FETCH csr_lookup INTO l_Meaning;
34: CLOSE csr_lookup;