APPS.HR_CONTRACT_API dependencies on PER_PERIODS_OF_SERVICE

Line 1225: from per_periods_of_service pps

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

Line 1232: l_start_date per_periods_of_service.date_start%type;

1228: and nvl(pps.actual_termination_date, hr_general.end_of_time);
1229:
1230: -- set up the variables
1231:
1232: l_start_date per_periods_of_service.date_start%type;
1233:
1234: begin
1235:
1236: open csr_date;

Line 1249: from per_periods_of_service pps

1245: (p_person_id in number,
1246: p_active_date in date) return date is
1247:
1248: cursor csr_date is select pps.actual_termination_date
1249: from per_periods_of_service pps
1250: where p_person_id=pps.person_id
1251: and p_active_date between pps.date_start
1252: and pps.actual_termination_date;
1253:

Line 1256: l_end_date per_periods_of_service.actual_termination_date%type;

1252: and pps.actual_termination_date;
1253:
1254: -- set up the variables
1255:
1256: l_end_date per_periods_of_service.actual_termination_date%type;
1257:
1258: begin
1259:
1260: open csr_date;