APPS.HR_CHANGE_START_DATE_API dependencies on PER_ADDRESSES

Line 2456: FROM PER_ADDRESSES

2452: -- modified for bug10213749
2453: cursor csr_addresses
2454: (p_person_id IN per_all_people_f.person_id%TYPE) IS
2455: SELECT count(1)
2456: FROM PER_ADDRESSES
2457: WHERE PERSON_ID = csr_addresses.p_person_id;
2458: --AND PRIMARY_FLAG='Y';
2459: l_count number;
2460: --bug#9266457

Line 2846: update per_addresses a

2842: OPEN csr_addresses(p_person_id);
2843: FETCH csr_addresses INTO l_count;
2844: CLOSE csr_addresses;
2845: if(l_count = 1) THEN
2846: update per_addresses a
2847: set a.date_from = l_new_start_date
2848: where a.date_from = l_old_start_date
2849: and nvl(a.date_to,l_new_start_date) >= l_new_start_date
2850: and a.person_id = p_person_id;