DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1073: ,per_assignment_status_types t

1069: LEAST(effective_end_date, c_end_date)
1070: - GREATEST(effective_start_date, c_start_date)),0)
1071: FROM
1072: per_assignments_f asg
1073: ,per_assignment_status_types t
1074: WHERE
1075: assignment_id = c_assignment_id
1076: AND t.assignment_status_type_id = asg.assignment_status_type_id
1077: AND effective_start_date <= c_end_date