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.PER_EEO_MAG_REPORT dependencies on PER_ASSIGNMENTS_F

Line 2006: FROM per_assignments_f ass1

2002: AND peo1.current_employee_flag = 'Y'
2003: )
2004: AND ass.effective_start_date =
2005: (SELECT MAX(ass1.effective_start_date)
2006: FROM per_assignments_f ass1
2007: WHERE p_start_date <= ass1.effective_end_date
2008: AND p_end_date >= ass1.effective_start_date
2009: AND ass.person_id = ass1.person_id
2010: AND ass1.assignment_type = 'E'

Line 2080: FROM per_assignments_f ass1

2076: AND peo1.current_employee_flag = 'Y'
2077: )
2078: AND ass.effective_start_date =
2079: (SELECT MAX(ass1.effective_start_date)
2080: FROM per_assignments_f ass1
2081: WHERE p_start_date <= ass1.effective_end_date
2082: AND p_end_date >= ass1.effective_start_date
2083: AND ass.person_id = ass1.person_id
2084: AND ass1.assignment_type = 'E'

Line 2149: FROM per_assignments_f ass1

2145: AND peo1.current_employee_flag = 'Y'
2146: )
2147: AND ass.effective_start_date =
2148: (SELECT MAX(ass1.effective_start_date)
2149: FROM per_assignments_f ass1
2150: WHERE p_start_date <= ass1.effective_end_date
2151: AND p_end_date >= ass1.effective_start_date
2152: AND ass.person_id = ass1.person_id
2153: AND ass1.assignment_type = 'E'