DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on HR_LOOKUPS

Line 17: FROM hr_lookups

13: FUNCTION GET_LOOKUP_MEANING (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
14:
15: CURSOR csr_lookup IS
16: SELECT meaning
17: FROM hr_lookups
18: WHERE lookup_type = p_lookup_type
19: AND lookup_code = p_lookup_code
20: AND enabled_flag = 'Y';
21:

Line 22: l_meaning hr_lookups.meaning%type;

18: WHERE lookup_type = p_lookup_type
19: AND lookup_code = p_lookup_code
20: AND enabled_flag = 'Y';
21:
22: l_meaning hr_lookups.meaning%type;
23:
24: BEGIN
25: OPEN csr_lookup;
26: FETCH csr_lookup INTO l_Meaning;