APPS.HR_APPLICANT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1868: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

1864: l_hourly_salaried_warning boolean;
1865: --
1866: l_assignment_status_id number;
1867: L_ASG_STATUS_OVN number;
1868: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1869: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1870: --
1871: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1872: --

Line 1869: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

1865: --
1866: l_assignment_status_id number;
1867: L_ASG_STATUS_OVN number;
1868: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1869: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1870: --
1871: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1872: --
1873: l_primary_flag per_assignments_f.primary_flag%TYPE;

Line 1944: from per_periods_of_service pps

1940: l_datetrack_mode varchar2(10):='UPDATE';
1941: cursor csr_pps_ended_ystrdy
1942: is
1943: select final_process_date
1944: from per_periods_of_service pps
1945: where pps.person_id = p_person_id
1946: and pps.actual_termination_date = p_hire_date-1;
1947: --bug no 5105005
1948: --bug no 12320120

Line 2188: from per_periods_of_service pps

2184: -- or FPD later than new hire date.
2185: cursor csr_pps_not_ended
2186: is
2187: select final_process_date
2188: from per_periods_of_service pps
2189: where pps.person_id = p_person_id
2190: and pps.actual_termination_date is not null
2191: and pps.date_start < p_hire_date
2192: and nvl(pps.final_process_date,p_hire_date) >= p_hire_date;

Line 3317: -- Insert the period of service into per_periods_of_service by calling the

3313: -- PTU : End of changes
3314:
3315:
3316: --
3317: -- Insert the period of service into per_periods_of_service by calling the
3318: -- Periods of Service table handler:
3319: --
3320: per_pds_ins.ins
3321: (p_business_group_id => l_business_group_id