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 767: FROM hr_lookups

763:
764: /* Cursor to fetch leaving reason meaning */
765: CURSOR csr_fetch_leav_reas (l_code varchar2) IS
766: SELECT meaning
767: FROM hr_lookups
768: WHERE lookup_type = 'LEAV_REAS'
769: AND lookup_code = l_code
770: AND enabled_flag = 'Y';
771:

Line 1388: FROM hr_lookups hl

1384: AND l_date between paf.effective_start_date and paf.effective_end_date;
1385:
1386: CURSOR csr_p_gender (l_sex varchar2) IS
1387: SELECT hl.meaning
1388: FROM hr_lookups hl
1389: WHERE hl.lookup_type = 'SEX'
1390: AND hl.lookup_code = l_sex
1391: AND hl.enabled_flag = 'Y';
1392:

Line 1521: FROM hr_lookups hl

1517:
1518: /* Cursor to fetch termination reason meaning */
1519: CURSOR csr_get_term_meaning (l_code varchar2) IS
1520: SELECT hl.meaning
1521: FROM hr_lookups hl
1522: WHERE hl.lookup_type = 'LEAV_REAS'
1523: AND hl.lookup_code = l_code
1524: AND hl.enabled_flag = 'Y';
1525:

Line 1536: FROM hr_lookups hl

1532:
1533: /* Cursor to fetch deduction_type meaning */
1534: CURSOR csr_get_ded_meaning (L_TYPE VARCHAR2) IS
1535: SELECT hl.meaning
1536: FROM hr_lookups hl
1537: WHERE hl.lookup_type = 'KW_DEDUCTION_CODES'
1538: AND hl.lookup_code = l_type
1539: AND hl.enabled_flag = 'Y';
1540: