APPS.HR_CHANGE_START_DATE_API dependencies on PER_ADDRESSES

Line 2390: update per_addresses a

2386: --
2387: -- Update the addresses that start at the old hire date
2388: -- Providing that addresses end date either equal to new start date or greater than it.
2389: --
2390: update per_addresses a
2391: set a.date_from = l_new_start_date
2392: where a.date_from = l_old_start_date
2393: and nvl(a.date_to,l_new_start_date) >= l_new_start_date
2394: and a.person_id = p_person_id;