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.HRI_DBI_WMV_SEPARATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 162: FROM per_all_assignments_f asg

158: ) IS
159: SELECT asg.supervisor_id supervisor_id,
160: MIN(pos.actual_termination_date-1) effective_start_date,
161: MAX(pos.actual_termination_date+1) effective_end_date
162: FROM per_all_assignments_f asg
163: , per_periods_of_service pos
164: WHERE asg.supervisor_id IS NOT NULL
165: AND asg.period_of_service_id = pos.period_of_service_id
166: AND pos.actual_termination_date <= TRUNC(SYSDATE)

Line 636: per_all_assignments_f asg

632: 'HEAD', wmv.head,
633: 0),
634: 0)) involuntary_separations
635: FROM
636: per_all_assignments_f asg
637: , per_periods_of_service pos
638: , per_assignment_status_types ast
639: , hri_cs_sepcr_v scr
640: , hri_mb_wmv wmv