APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PERIODS_OF_SERVICE

Line 127: FROM per_periods_of_service pds

123: )
124: IS
125: SELECT pds.period_of_service_id
126: ,pds.object_version_number
127: FROM per_periods_of_service pds
128: WHERE pds.person_id = csr_pds_details.p_person_id
129: AND csr_pds_details.p_effective_date BETWEEN pds.date_start
130: AND NVL(pds.actual_termination_date,hr_api.g_eot);
131: --

Line 1537: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

1533: l_oversubscribed_vacancy_id number;
1534: --Added for 5277866
1535: l_check_loop number:=0;
1536: --
1537: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1538: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1539: --
1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1541: --

Line 1538: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

1534: --Added for 5277866
1535: l_check_loop number:=0;
1536: --
1537: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1538: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1539: --
1540: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1541: --
1542: l_primary_flag per_assignments_f.primary_flag%TYPE;