APPS.PER_PEOPLE4_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 206: from per_periods_of_service pps

202: END IF;
203: begin
204: select pps.period_of_service_id
205: into l_period_of_service_id
206: from per_periods_of_service pps
207: where pps.person_id = p_person_id
208: and pps.date_start = p_s_hire_date;
209: --
210: exception

Line 939: from per_periods_of_service pps

935: IS
936: cursor old_pps_exists
937: is
938: select 1
939: from per_periods_of_service pps
940: where pps.person_id = p_person_id
941: and pps.actual_termination_date is not null;
942: --
943: -- 70.11 nvl(pps.final_process_date,p_start_date)+1 < p_start_date;

Line 948: from per_periods_of_service pps

944: --
945: cursor pps_not_ended
946: is
947: select pps.final_process_date
948: from per_periods_of_service pps
949: where pps.person_id = p_person_id
950: and pps.date_start = (select max(date_start)
951: from per_periods_of_service pps1
952: where pps1.person_id = pps.person_id

Line 951: from per_periods_of_service pps1

947: select pps.final_process_date
948: from per_periods_of_service pps
949: where pps.person_id = p_person_id
950: and pps.date_start = (select max(date_start)
951: from per_periods_of_service pps1
952: where pps1.person_id = pps.person_id
953: and pps1.date_start 954: )
955: and nvl(pps.final_process_date,p_start_date) >= p_start_date;

Line 1054: from per_periods_of_service pps

1050:
1051: -- Start changes for bug 11062773
1052: cursor csr_is_first_pps is
1053: select period_of_service_id
1054: from per_periods_of_service pps
1055: where period_of_service_id = p_period_of_service_id
1056: and 1 = (
1057: select count(1)
1058: from per_periods_of_service

Line 1058: from per_periods_of_service

1054: from per_periods_of_service pps
1055: where period_of_service_id = p_period_of_service_id
1056: and 1 = (
1057: select count(1)
1058: from per_periods_of_service
1059: where person_id = p_person_id
1060: );
1061: -- End changes for bug 11062773
1062:

Line 1075: from per_periods_of_service

1071:
1072: --
1073: cursor csr_earliest_date is
1074: select min(date_start)
1075: from per_periods_of_service
1076: where p_person_id = person_id;
1077: --
1078: l_proc varchar2(21) := 'original_date_of_hire';
1079: --