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.HXT_TRAN_PA dependencies on PER_PEOPLE_F

Line 44: per_people_f ppf

40: FROM hxt_timecards_x tim,
41: per_time_periods ptp,
42: per_time_period_types ptpt,
43: pay_batch_headers ppbh,
44: per_people_f ppf
45: WHERE tim.payroll_id = c_payroll_id
46: AND ptp.time_period_id BETWEEN NVL(c_time_period_id,1)
47: AND NVL(c_time_period_id,999999999)
48: AND tim.time_period_id = ptp.time_period_id

Line 55: from per_people_f ppf2

51: AND ppbh.batch_status <> 'U'
52: AND ppf.person_id = tim.for_person_id
53: AND ppf.effective_start_date =
54: (select MAX (ppf2.effective_start_date) -- to handle mid pay period changes
55: from per_people_f ppf2
56: where ppf2.person_id = tim.for_person_id
57: and ppf2.effective_end_date >= ptp.START_date
58: and ppf2.effective_start_date <= ptp.END_date)
59: AND EXISTS (SELECT 'Y'