APPS.PER_ASSIGNMENTS_V7_PKG dependencies on HR_GENERAL

Line 1089: and p.effective_end_date <> hr_general.end_of_time

1085: cursor get_previous_changes is
1086: select 'Y'
1087: from per_assignments_f p
1088: where p.effective_start_date < x_effective_start_date
1089: and p.effective_end_date <> hr_general.end_of_time
1090: and p.assignment_id = x_assignment_id
1091: and p.effective_start_date = (select max(p1.effective_start_date)
1092: from per_assignments_f p1
1093: where p1.assignment_id = p.assignment_id);