APPS.HR_CHANGE_START_DATE_API dependencies on PER_APPLICATIONS

Line 1637: from per_applications a

1633: ,p_old_start_date date
1634: ,p_new_start_date date) is
1635: cursor csr_apl is
1636: select application_id
1637: from per_applications a
1638: where a.person_id = p_person_id
1639: and a.date_received =
1640: (select max(a2.date_received)
1641: from per_applications a2

Line 1641: from per_applications a2

1637: from per_applications a
1638: where a.person_id = p_person_id
1639: and a.date_received =
1640: (select max(a2.date_received)
1641: from per_applications a2
1642: where a2.person_id = a.person_id
1643: and a2.date_received < p_new_start_date);
1644: --
1645: l_application_id number;

Line 1652: update per_applications a1

1648: open csr_apl;
1649: loop
1650: fetch csr_apl into l_application_id;
1651: exit when csr_apl%NOTFOUND;
1652: update per_applications a1
1653: set a1.date_end = p_new_start_date - 1
1654: where a1.application_id = l_application_id
1655: and not exists (select 1
1656: from per_people_f peo

Line 1663: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');

1659: and peo.effective_start_date = p_old_start_date
1660: and peo.current_applicant_flag = 'Y');
1661: if sql%rowcount <1 then
1662: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1663: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1664: hr_utility.raise_error;
1665: end if;
1666: end loop;
1667: close csr_apl;