DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PER_TIME_PERIODS

Line 185: , per_time_periods ptp

181: , pay_assignment_actions assact
182: , pay_payroll_actions pact
183: , fnd_sessions s
184: , per_periods_of_service pos
185: , per_time_periods ptp
186: where ou.organization_id = pay_magtape_generic.get_parameter_value('REGISTERED_EMPLOYER')
187: and ou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
188: and b.organization_id = to_char(ou.organization_id)
189: and p.effective_start_date <= last_day(s.effective_date)

Line 206: FROM per_time_periods

202: -- and pos.DATE_START between ptp.START_DATE and ptp.END_DATE /*2276649*/
203: -- and ptp.PAYROLL_ID = a.PAYROLL_ID
204: --
205: AND (ptp.payroll_id,ptp.start_date) = (SELECT payroll_id,MIN(start_date)
206: FROM per_time_periods
207: WHERE payroll_id = a.payroll_id
208: AND end_date > pos.date_start
209: GROUP BY payroll_id)
210: -- end TAR 2188761.995 change