APPS.PER_EEO_MAG_REPORT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1982: ,per_assignment_status_types ast --Added for bug##12616269

1978: and peo1.current_employee_flag = 'Y'
1979: )
1980: AND ass.effective_start_date = (select max(ass1.effective_start_date)
1981: from per_all_assignments_f ass1
1982: ,per_assignment_status_types ast --Added for bug##12616269
1983: where p_start_date <= ass1.effective_end_date
1984: and p_end_date >= ass1.effective_start_date
1985: and ass.person_id = ass1.person_id
1986: and ass1.assignment_type = 'E'

Line 2085: ,per_assignment_status_types ast --Added for bug##12616269

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
2089: AND ass1.assignment_type = 'E'

Line 2189: ,per_assignment_status_types ast --Added for bug##12616269

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
2193: AND ass1.assignment_type = 'E'

Line 2264: ,per_assignment_status_types ast --Added for bug##12616269

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
2268: AND ass1.assignment_type = 'E'