APPS.PER_ASSIGNMENTS_V7_PKG dependencies on HR_GENERAL

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

1090: cursor get_previous_changes is
1091: select 'Y'
1092: from per_assignments_f p
1093: where p.effective_start_date < x_effective_start_date
1094: and p.effective_end_date <> hr_general.end_of_time
1095: and p.assignment_id = x_assignment_id
1096: and p.effective_start_date = (select max(p1.effective_start_date)
1097: from per_assignments_f p1
1098: where p1.assignment_id = p.assignment_id);