APPS.HR_CHANGE_START_DATE_API dependencies on PER_APPLICATIONS

Line 1244: from per_applications a

1240: ,p_old_start_date date
1241: ,p_new_start_date date) is
1242: cursor csr_apl is
1243: select application_id
1244: from per_applications a
1245: where a.person_id = p_person_id
1246: and a.date_received =
1247: (select max(a2.date_received)
1248: from per_applications a2

Line 1248: from per_applications a2

1244: from per_applications a
1245: where a.person_id = p_person_id
1246: and a.date_received =
1247: (select max(a2.date_received)
1248: from per_applications a2
1249: where a2.person_id = a.person_id
1250: and a2.date_received < p_new_start_date);
1251: --
1252: l_application_id number;

Line 1259: update per_applications a1

1255: open csr_apl;
1256: loop
1257: fetch csr_apl into l_application_id;
1258: exit when csr_apl%NOTFOUND;
1259: update per_applications a1
1260: set a1.date_end = p_new_start_date - 1
1261: where a1.application_id = l_application_id
1262: and not exists (select 1
1263: from per_people_f peo

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

1266: and peo.effective_start_date = p_old_start_date
1267: and peo.current_applicant_flag = 'Y');
1268: if sql%rowcount <1 then
1269: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1270: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
1271: hr_utility.raise_error;
1272: end if;
1273: end loop;
1274: close csr_apl;