APPS.HR_CONTRACT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1202: from per_periods_of_service pps

1198: (p_person_id in number,
1199: p_active_date in date) return date is
1200:
1201: cursor csr_date is select pps.date_start
1202: from per_periods_of_service pps
1203: where p_person_id=pps.person_id
1204: and p_active_date between pps.date_start
1205: and nvl(pps.actual_termination_date, hr_general.end_of_time);
1206:

Line 1209: l_start_date per_periods_of_service.date_start%type;

1205: and nvl(pps.actual_termination_date, hr_general.end_of_time);
1206:
1207: -- set up the variables
1208:
1209: l_start_date per_periods_of_service.date_start%type;
1210:
1211: begin
1212:
1213: open csr_date;

Line 1226: from per_periods_of_service pps

1222: (p_person_id in number,
1223: p_active_date in date) return date is
1224:
1225: cursor csr_date is select pps.actual_termination_date
1226: from per_periods_of_service pps
1227: where p_person_id=pps.person_id
1228: and p_active_date between pps.date_start
1229: and pps.actual_termination_date;
1230:

Line 1233: l_end_date per_periods_of_service.actual_termination_date%type;

1229: and pps.actual_termination_date;
1230:
1231: -- set up the variables
1232:
1233: l_end_date per_periods_of_service.actual_termination_date%type;
1234:
1235: begin
1236:
1237: open csr_date;