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 2084: FROM per_assignments_f ass1

2080: AND peo1.current_employee_flag = 'Y'
2081: )
2082: AND ass.effective_start_date =
2083: (SELECT MAX(ass1.effective_start_date)
2084: FROM per_assignments_f ass1
2085: ,per_assignment_status_types ast --Added for bug##12616269
2086: WHERE p_start_date <= ass1.effective_end_date
2087: AND p_end_date >= ass1.effective_start_date
2088: AND ass.person_id = ass1.person_id

Line 2188: FROM per_assignments_f ass1

2184: AND peo1.current_employee_flag = 'Y'
2185: )
2186: AND ass.effective_start_date =
2187: (SELECT MAX(ass1.effective_start_date)
2188: FROM per_assignments_f ass1
2189: ,per_assignment_status_types ast --Added for bug##12616269
2190: WHERE p_start_date <= ass1.effective_end_date
2191: AND p_end_date >= ass1.effective_start_date
2192: AND ass.person_id = ass1.person_id

Line 2263: FROM per_assignments_f ass1

2259: AND peo1.current_employee_flag = 'Y'
2260: )
2261: AND ass.effective_start_date =
2262: (SELECT MAX(ass1.effective_start_date)
2263: FROM per_assignments_f ass1
2264: ,per_assignment_status_types ast --Added for bug##12616269
2265: WHERE p_start_date <= ass1.effective_end_date
2266: AND p_end_date >= ass1.effective_start_date
2267: AND ass.person_id = ass1.person_id