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_IE_WNU_EDI dependencies on PER_PERIODS_OF_SERVICE

Line 165: per_periods_of_service serv,

161: ppa.effective_date effective_date
162: from per_all_assignments_f asg,
163: pay_payroll_actions ppa,
164: per_all_people_f pap,
165: per_periods_of_service serv,
166: -- hr_organization_information hoi,
167: pay_all_payrolls_f pay,
168: hr_soft_coding_keyflex sck
169: where ppa.payroll_action_id = pactid

Line 208: from per_periods_of_service s

204: and asg.person_id = pap.person_id
205: and serv.person_id = pap.person_id
206: and serv.period_of_service_id = asg.period_of_service_id
207: and serv.date_start = (select max(s.date_start)
208: from per_periods_of_service s
209: where s.person_id = pap.person_id
210: and ppa.effective_date >= s.date_start)
211: and pap.current_employee_flag = 'Y'
212: and asg.person_id between

Line 324: per_periods_of_service serv,

320: ppa.effective_date effective_date
321: from per_all_assignments_f asg,
322: pay_payroll_actions ppa,
323: per_all_people_f pap,
324: per_periods_of_service serv,
325: per_assignment_extra_info aei,
326: -- hr_organization_information hoi,
327: pay_all_payrolls_f pay,
328: hr_soft_coding_keyflex sck

Line 365: from per_periods_of_service s

361: and asg.person_id = pap.person_id
362: and serv.person_id = pap.person_id
363: and serv.period_of_service_id = asg.period_of_service_id
364: and serv.date_start = (select max(s.date_start)
365: from per_periods_of_service s
366: where s.person_id = pap.person_id
367: and ppa.effective_date >= s.date_start)
368: and pap.current_employee_flag = 'Y'
369: and asg.assignment_id = aei.assignment_id