APPS.PAY_KW_ANNUAL_REPORTS dependencies on HR_LOOKUPS

Line 28: from hr_lookups

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

Line 31: l_meaning hr_lookups.meaning%type;

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

Line 825: FROM hr_lookups

821:
822: /* Cursor to fetch leaving reason meaning */
823: CURSOR csr_fetch_leav_reas (l_code varchar2) IS
824: SELECT meaning
825: FROM hr_lookups
826: WHERE lookup_type = 'LEAV_REAS'
827: AND lookup_code = l_code
828: AND enabled_flag = 'Y';
829:

Line 1446: FROM hr_lookups hl

1442: AND l_date between paf.effective_start_date and paf.effective_end_date;
1443:
1444: CURSOR csr_p_gender (l_sex varchar2) IS
1445: SELECT hl.meaning
1446: FROM hr_lookups hl
1447: WHERE hl.lookup_type = 'SEX'
1448: AND hl.lookup_code = l_sex
1449: AND hl.enabled_flag = 'Y';
1450:

Line 1579: FROM hr_lookups hl

1575:
1576: /* Cursor to fetch termination reason meaning */
1577: CURSOR csr_get_term_meaning (l_code varchar2) IS
1578: SELECT hl.meaning
1579: FROM hr_lookups hl
1580: WHERE hl.lookup_type = 'LEAV_REAS'
1581: AND hl.lookup_code = l_code
1582: AND hl.enabled_flag = 'Y';
1583:

Line 1594: FROM hr_lookups hl

1590:
1591: /* Cursor to fetch deduction_type meaning */
1592: CURSOR csr_get_ded_meaning (L_TYPE VARCHAR2) IS
1593: SELECT hl.meaning
1594: FROM hr_lookups hl
1595: WHERE hl.lookup_type = 'KW_DEDUCTION_CODES'
1596: AND hl.lookup_code = l_type
1597: AND hl.enabled_flag = 'Y';
1598: