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_RETRO_PA dependencies on PER_PEOPLE_F

Line 47: per_people_f ppf

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

Line 57: from per_people_f ppf2

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