APPS.HR_APPLICANT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1541: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

1537: l_hourly_salaried_warning boolean;
1538: --
1539: l_assignment_status_id number;
1540: L_ASG_STATUS_OVN number;
1541: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1542: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1543: --
1544: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1545: --

Line 1542: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

1538: --
1539: l_assignment_status_id number;
1540: L_ASG_STATUS_OVN number;
1541: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1542: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1543: --
1544: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1545: --
1546: l_primary_flag per_assignments_f.primary_flag%TYPE;

Line 1565: from per_periods_of_service pps

1561: l_datetrack_mode varchar2(10):='UPDATE';
1562: cursor csr_pps_ended_ystrdy
1563: is
1564: select final_process_date
1565: from per_periods_of_service pps
1566: where pps.person_id = p_person_id
1567: and pps.actual_termination_date = p_hire_date-1;
1568: --bug no 5105005
1569:

Line 1782: from per_periods_of_service pps

1778: -- or FPD later than new hire date.
1779: cursor csr_pps_not_ended
1780: is
1781: select final_process_date
1782: from per_periods_of_service pps
1783: where pps.person_id = p_person_id
1784: and pps.actual_termination_date is not null
1785: and pps.date_start < p_hire_date
1786: and nvl(pps.final_process_date,p_hire_date) >= p_hire_date;

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

2471: -- PTU : End of changes
2472:
2473: hr_utility.set_location(l_proc,290);
2474: --
2475: -- Insert the period of service into per_periods_of_service by calling the
2476: -- Periods of Service table handler:
2477: --
2478: per_pds_ins.ins
2479: (p_business_group_id => l_business_group_id