APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 308: from per_periods_of_service pps

304: -- Period cursor
305: --
306: cursor period_rows is
307: select pps.rowid
308: from per_periods_of_service pps
309: where pps.person_id = p_person_id
310: for update of pps.person_id;
311: --
312: -- applicant cursor

Line 1377: from per_periods_of_service pps

1373: -- Period cursor
1374: --
1375: cursor period is
1376: select pps.rowid
1377: from per_periods_of_service pps
1378: where pps.person_id = p_person_id
1379: and period_of_service_id = l_period_of_service_id;
1380: --
1381: -- person cursor

Line 1481: from per_periods_of_service pps

1477: --
1478: begin
1479: select pps.period_of_service_id
1480: into v_dummy
1481: from per_periods_of_service pps
1482: where p_start_date = pps.date_start
1483: and pps.person_id = p_person_id;
1484: --
1485: return v_dummy;

Line 1797: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

1793: end loop entries;
1794: close ass1;
1795: --
1796: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',290);
1797: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
1798: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_date_start);
1799:
1800: open period;
1801: <>

Line 1806: delete from per_periods_of_service

1802: loop
1803: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',300);
1804: fetch period into p_rowid;
1805: exit when period%notfound;
1806: delete from per_periods_of_service
1807: where rowid = p_rowid;
1808: if sql%notfound then
1809: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1810: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 3465: FROM per_periods_of_service ps

3461: AND pp.actual_termination_date = p_date_start -1;
3462: --
3463: CURSOR csr_pos_back_to_back (p_date_start IN DATE) IS
3464: SELECT ps.period_of_service_id
3465: FROM per_periods_of_service ps
3466: WHERE ps.person_id = p_person_id
3467: AND ps.actual_termination_date = p_date_start -1;
3468: --
3469: