APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 476: from per_periods_of_service pps

472: -- Period cursor
473: --
474: cursor period_rows is
475: select pps.rowid
476: from per_periods_of_service pps
477: where pps.person_id = p_person_id
478: for update of pps.person_id;
479: --
480: -- applicant cursor

Line 1532: from per_periods_of_service pps

1528: -- Period cursor
1529: --
1530: cursor period is
1531: select pps.rowid
1532: from per_periods_of_service pps
1533: where pps.person_id = p_person_id
1534: and period_of_service_id = l_period_of_service_id;
1535: --
1536: -- person cursor

Line 1635: from per_periods_of_service pps

1631: --
1632: begin
1633: select pps.period_of_service_id
1634: into v_dummy
1635: from per_periods_of_service pps
1636: where p_start_date = pps.date_start
1637: and pps.person_id = p_person_id;
1638: --
1639: return v_dummy;

Line 2297: from per_periods_of_service pps

2293: -- Period cursor
2294: --
2295: cursor period is
2296: select pps.rowid
2297: from per_periods_of_service pps
2298: where pps.person_id = p_person_id
2299: and period_of_service_id = l_period_of_service_id;
2300: --
2301: -- person cursor

Line 2401: from per_periods_of_service pps

2397: --
2398: begin
2399: select pps.period_of_service_id
2400: into v_dummy
2401: from per_periods_of_service pps
2402: where p_start_date = pps.date_start
2403: and pps.person_id = p_person_id;
2404: --
2405: return v_dummy;

Line 2751: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

2747: end loop entries;
2748: close ass1;
2749: --
2750: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',290);
2751: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
2752: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_date_start);
2753:
2754: open period;
2755: <>

Line 2760: delete from per_periods_of_service

2756: loop
2757: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',300);
2758: fetch period into p_rowid;
2759: exit when period%notfound;
2760: delete from per_periods_of_service
2761: where rowid = p_rowid;
2762: if sql%notfound then
2763: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2764: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 4692: FROM per_periods_of_service ps

4688: AND pp.actual_termination_date = p_date_start -1;
4689: --
4690: CURSOR csr_pos_back_to_back (p_date_start IN DATE) IS
4691: SELECT ps.period_of_service_id
4692: FROM per_periods_of_service ps
4693: WHERE ps.person_id = p_person_id
4694: AND ps.actual_termination_date = p_date_start -1;
4695: --
4696: