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

Line 193: ,per_time_periods ptp

189: asg.payroll_id
190: ,ptp.time_period_id
191: from
192: per_all_assignments_f asg
193: ,per_time_periods ptp
194: where
195: asg.assignment_id = p_assignment_id
196: and p_effective_date between
197: asg.effective_start_date and asg.effective_end_date

Line 602: ,per_time_periods ptp

598: select
599: 1
600: from
601: per_all_assignments_f asg
602: ,per_time_periods ptp
603: where
604: asg.assignment_id = p_assignment_id
605: and p_effective_date between asg.effective_start_date
606: and asg.effective_end_date

Line 629: ,per_time_periods ptp

625: select
626: asg.effective_end_date end_date
627: from
628: per_all_assignments_f asg
629: ,per_time_periods ptp
630: where
631: asg.assignment_id = p_assignment_id
632: and asg.effective_end_date <= p_effective_date
633: and ptp.payroll_id = asg.payroll_id

Line 647: ,per_time_periods ptp

643: select
644: ptp.end_date end_date
645: from
646: per_all_assignments_f asg
647: ,per_time_periods ptp
648: where
649: asg.assignment_id = p_assignment_id
650: and asg.effective_start_date <= p_effective_date
651: and ptp.payroll_id = asg.payroll_id