DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on HR_LOOKUPS

Line 18: FROM hr_lookups

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

Line 23: l_meaning hr_lookups.meaning%type;

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