eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EMP_ACTION_ARCH dependencies on HR_LOOKUPS

Line 1539: from hr_lookups hl

1535:
1536: cursor c_get_asg_frequency(cp_frequency in varchar2
1537: ,cp_effective_date in date) is
1538: select meaning
1539: from hr_lookups hl
1540: where hl.lookup_type = 'FREQUENCY'
1541: and hl.enabled_flag = 'Y'
1542: and hl.lookup_code = cp_frequency
1543: and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)

Line 1628: from hr_lookups hl

1624:
1625: cursor c_get_bargaining_unit(cp_bargaining_unit in varchar2
1626: ,cp_effective_date in date) is
1627: select meaning
1628: from hr_lookups hl
1629: where hl.lookup_type = 'BARGAINING_UNIT_CODE'
1630: and hl.enabled_flag = 'Y'
1631: and hl.lookup_code = cp_bargaining_unit
1632: and cp_effective_date between nvl(hl.start_date_active, cp_effective_date)

Line 1733: from hr_lookups hl

1729:
1730: cursor c_get_hourly_salaried_code(cp_hourly_salaried_code in varchar2
1731: ,cp_effective_date in date) is
1732: select hl.meaning
1733: from hr_lookups hl
1734: where hl.lookup_type='HOURLY_SALARIED_CODE'
1735: and hl.lookup_code = cp_hourly_salaried_code
1736: and hl.enabled_flag='Y'
1737: and cp_effective_date between

Line 1785: from hr_lookups hl

1781:
1782: cursor c_get_shift_desc(cp_shift_code in varchar2
1783: ,cp_effective_date in date) is
1784: select hl.meaning
1785: from hr_lookups hl
1786: where hl.lookup_type='US_SHIFTS'
1787: and hl.lookup_code = cp_shift_code
1788: and hl.enabled_flag='Y'
1789: and hl.application_id = 800