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 1751: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

1747: l_oversubscribed_vacancy_id number;
1748: --Added for 5277866
1749: l_check_loop number:=0;
1750: --
1751: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1752: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1753: --
1754: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1755: --

Line 1752: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

1748: --Added for 5277866
1749: l_check_loop number:=0;
1750: --
1751: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1752: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
1753: --
1754: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
1755: --
1756: l_primary_flag per_assignments_f.primary_flag%TYPE;

Line 4216: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

4212: l_oversubscribed_vacancy_id number;
4213: --Added for 5277866
4214: l_check_loop number:=0;
4215: --
4216: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4217: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
4218: --
4219: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4220: --

Line 4217: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

4213: --Added for 5277866
4214: l_check_loop number:=0;
4215: --
4216: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4217: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
4218: --
4219: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4220: --
4221: l_primary_flag per_assignments_f.primary_flag%TYPE;