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_ALL_ASSIGNMENTS_F

Line 192: per_all_assignments_f asg

188: -- Assignment information
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

Line 601: per_all_assignments_f asg

597: is
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

Line 628: per_all_assignments_f asg

624: --
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

Line 646: per_all_assignments_f asg

642: --
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