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_NZ_EMS dependencies on PER_TIME_PERIODS

Line 232: , per_time_periods ptp

228: , pay_assignment_actions assact
229: , pay_payroll_actions pact
230: , fnd_sessions s
231: , per_periods_of_service pos
232: , per_time_periods ptp
233: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
234: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
235: and b.organization_id = to_char(ou.organization_id)
236: and p.effective_start_date <= last_day(s.effective_date)

Line 253: FROM per_time_periods

249: -- and pos.DATE_START between ptp.START_DATE and ptp.END_DATE /*2276649*/
250: -- and ptp.PAYROLL_ID = a.PAYROLL_ID
251: --
252: AND (ptp.payroll_id,ptp.start_date) = (SELECT payroll_id,MIN(start_date)
253: FROM per_time_periods
254: WHERE payroll_id = a.payroll_id
255: AND end_date > pos.date_start
256: GROUP BY payroll_id)
257: -- end TAR 2188761.995 change