DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2295: ,per_assignment_status_types t

2291: LEAST(effective_end_date, c_end_date)
2292: - GREATEST(effective_start_date, c_start_date)),0)
2293: FROM
2294: per_assignments_f asg
2295: ,per_assignment_status_types t
2296: WHERE
2297: assignment_id = c_assignment_id
2298: AND t.assignment_status_type_id = asg.assignment_status_type_id
2299: AND effective_start_date <= c_end_date