APPS.PER_PEOPLE12_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 678: from per_periods_of_service pps

674: end if;
675: begin
676: select pps.period_of_service_id
677: into l_period_of_service_id
678: from per_periods_of_service pps
679: where pps.person_id = p_person_id
680: and pps.date_start = p_s_hire_date;
681: --
682: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',25);

Line 954: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

950: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',120);
951:
952: -- PTU Changes
953:
954: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
955: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
956: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
957: and p_system_person_type = 'EMP'
958: -- and p_session_date = p_effective_start_date then

Line 1283: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

1279: ,p_person_id => p_person_id
1280: ,p_person_type_id => p_person_type_id
1281: );
1282: */
1283: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
1284: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
1285: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL')
1286: and p_system_person_type = 'EMP'
1287: -- and p_session_date = p_effective_start_date then

Line 1830: from per_periods_of_service pps

1826: IS
1827: cursor old_pps_exists
1828: is
1829: select 1
1830: from per_periods_of_service pps
1831: where pps.person_id = p_person_id
1832: and pps.actual_termination_date is not null;
1833: --
1834: -- 70.11 nvl(pps.final_process_date,p_start_date)+1 < p_start_date;

Line 1847: from per_periods_of_service pps

1843: pps.final_process_date
1844: --
1845: -- 115.67 (END)
1846: --
1847: from per_periods_of_service pps
1848: where pps.person_id = p_person_id
1849: and pps.date_start = (select max(date_start)
1850: from per_periods_of_service pps1
1851: where pps1.person_id = pps.person_id

Line 1850: from per_periods_of_service pps1

1846: --
1847: from per_periods_of_service pps
1848: where pps.person_id = p_person_id
1849: and pps.date_start = (select max(date_start)
1850: from per_periods_of_service pps1
1851: where pps1.person_id = pps.person_id
1852: and pps1.date_start 1853: )
1854: and nvl(pps.final_process_date,p_start_date) >= p_start_date;

Line 2405: from per_periods_of_service

2401: group by ctr.person_id;
2402: --
2403: cursor csr_last_hire_date(c_person_id number) is
2404: select max(date_start)
2405: from per_periods_of_service
2406: where person_id = c_person_id;
2407: --
2408: l_proc varchar2(100) := 'per_people12_pkg.maintain_coverage';
2409: l_cov_date_start date;