APPS.PER_PEOPLE12_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 465: from per_periods_of_service pps

461: end if;
462: begin
463: select pps.period_of_service_id
464: into l_period_of_service_id
465: from per_periods_of_service pps
466: where pps.person_id = p_person_id
467: and pps.date_start = p_s_hire_date;
468: --
469: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',25);

Line 740: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

736: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2',120);
737:
738: -- PTU Changes
739:
740: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
741: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
742: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
743: and p_system_person_type = 'EMP'
744: -- and p_session_date = p_effective_start_date then

Line 1066: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

1062: ,p_person_id => p_person_id
1063: ,p_person_type_id => p_person_type_id
1064: );
1065: */
1066: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
1067: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
1068: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL')
1069: and p_system_person_type = 'EMP'
1070: -- and p_session_date = p_effective_start_date then

Line 2939: from per_periods_of_service pps

2935: end if;
2936: begin
2937: select pps.period_of_service_id
2938: into l_period_of_service_id
2939: from per_periods_of_service pps
2940: where pps.person_id = p_person_id
2941: and pps.date_start = p_s_hire_date;
2942: --
2943: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',25);

Line 3215: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

3211: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1',120);
3212:
3213: -- PTU Changes
3214:
3215: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
3216: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
3217: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL') -- Bug 3637893
3218: and p_system_person_type = 'EMP'
3219: -- and p_session_date = p_effective_start_date then

Line 3544: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract

3540: ,p_person_id => p_person_id
3541: ,p_person_type_id => p_person_type_id
3542: );
3543: */
3544: l_back2back := per_periods_of_service_pkg_v2.IsBackToBackContract
3545: ( p_person_id => p_person_id, p_hire_date_of_current_pds => p_effective_start_date);
3546: if p_s_system_person_type in ('EX_EMP','EX_EMP_APL')
3547: --and p_system_person_type = 'EMP' --Commented for Bug#15848881
3548: and p_system_person_type in ('EMP','EMP_APL') --Added for Bug#15848881

Line 4153: from per_periods_of_service pps

4149: IS
4150: cursor old_pps_exists
4151: is
4152: select 1
4153: from per_periods_of_service pps
4154: where pps.person_id = p_person_id
4155: and pps.actual_termination_date is not null;
4156: --
4157: -- 70.11 nvl(pps.final_process_date,p_start_date)+1 < p_start_date;

Line 4170: from per_periods_of_service pps

4166: pps.final_process_date
4167: --
4168: -- 115.67 (END)
4169: --
4170: from per_periods_of_service pps
4171: where pps.person_id = p_person_id
4172: and pps.date_start = (select max(date_start)
4173: from per_periods_of_service pps1
4174: where pps1.person_id = pps.person_id

Line 4173: from per_periods_of_service pps1

4169: --
4170: from per_periods_of_service pps
4171: where pps.person_id = p_person_id
4172: and pps.date_start = (select max(date_start)
4173: from per_periods_of_service pps1
4174: where pps1.person_id = pps.person_id
4175: and pps1.date_start 4176: )
4177: and nvl(pps.final_process_date,p_start_date) >= p_start_date;

Line 4728: from per_periods_of_service

4724: group by ctr.person_id;
4725: --
4726: cursor csr_last_hire_date(c_person_id number) is
4727: select max(date_start)
4728: from per_periods_of_service
4729: where person_id = c_person_id;
4730: --
4731: l_proc varchar2(100) := 'per_people12_pkg.maintain_coverage';
4732: l_cov_date_start date;