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_US_HR_HELPDESK dependencies on HR_LOOKUPS

Line 26: ,hr_lookups hl

22: from pay_payroll_actions ppa
23: ,pay_assignment_actions paa
24: ,per_assignments_f paf
25: ,per_people_f ppf
26: ,hr_lookups hl
27: where ppa.action_type = 'X'
28: and ppa.action_status = 'C'
29: and ppa.report_type = hl.meaning
30: and hl.lookup_type = 'PAYSLIP_REPORT_TYPES'

Line 39: ,hr_lookups hl1

35: and ppf.person_id = l_person_id
36: and ppa.effective_date = (select max(ppa1.effective_date)
37: from pay_payroll_actions ppa1
38: ,pay_assignment_actions paa1
39: ,hr_lookups hl1
40: where ppa1.effective_date <= l_eff_date
41: and ppa1.action_type = 'X'
42: and ppa1.action_status = 'C'
43: and ppa1.report_type = hl1.meaning