APPS.PAY_EMP_ACTION_ARCH dependencies on HR_LOOKUPS

Line 1469: from hr_lookups hl

1465:
1466: cursor c_get_asg_frequency(cp_frequency in varchar2
1467: ,cp_effective_date in date) is
1468: select meaning
1469: from hr_lookups hl
1470: where hl.lookup_type = 'FREQUENCY'
1471: and hl.enabled_flag = 'Y'
1472: and hl.lookup_code = cp_frequency
1473: and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)

Line 1558: from hr_lookups hl

1554:
1555: cursor c_get_bargaining_unit(cp_bargaining_unit in varchar2
1556: ,cp_effective_date in date) is
1557: select meaning
1558: from hr_lookups hl
1559: where hl.lookup_type = 'BARGAINING_UNIT_CODE'
1560: and hl.enabled_flag = 'Y'
1561: and hl.lookup_code = cp_bargaining_unit
1562: and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)

Line 1663: from hr_lookups hl

1659:
1660: cursor c_get_hourly_salaried_code(cp_hourly_salaried_code in varchar2
1661: ,cp_effective_date in date) is
1662: select hl.meaning
1663: from hr_lookups hl
1664: where hl.lookup_type='HOURLY_SALARIED_CODE'
1665: and hl.lookup_code = cp_hourly_salaried_code
1666: and hl.enabled_flag='Y'
1667: and cp_effective_date between

Line 1720: from hr_lookups hl

1716: hr_utility.trace('shift_code = ' || lv_shift_code);
1717: /* check this one out as it is legislation specific
1718: select hl.meaning
1719: into lv_shift_desc
1720: from hr_lookups hl
1721: where hl.lookup_type='US_SHIFTS'
1722: and hl.lookup_code = lv_shift_code
1723: and hl.enabled_flag='Y'
1724: and hl.application_id = 800