APPS.SSP_SSP_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 296: per_periods_of_service SERVICE

292: hr_general.end_of_time) FINAL_PROCESS_DATE,
293: /* 7688727 End */
294: service.leaving_reason
295: from per_all_people_f PERSON,
296: per_periods_of_service SERVICE
297: where person.person_id = p_person_id
298: and service.person_id = person.person_id
299: and p_date_start between service.date_start
300: and nvl (service.actual_termination_date,

Line 1486: l_PERIOD_OF_SERVICE_ID PER_PERIODS_OF_SERVICE.PERIOD_OF_SERVICE_ID%type;

1482: sickness_start_date >= p_start_date)
1483: order by sickness_start_date desc;
1484: */
1485:
1486: l_PERIOD_OF_SERVICE_ID PER_PERIODS_OF_SERVICE.PERIOD_OF_SERVICE_ID%type;
1487:
1488: cursor PIW_series(p_start_date date) is
1489: select sickness_start_date,
1490: sickness_end_date,

Line 1493: per_periods_of_service service

1489: select sickness_start_date,
1490: sickness_end_date,
1491: absence_attendance_id
1492: from per_absence_attendances per,
1493: per_periods_of_service service
1494: where per.person_id = p_person_id
1495: and per.sickness_start_date is not null
1496: and per.sickness_start_date < p_sickness_start_date
1497: and (p_start_date is null or

Line 1504: select PERIOD_OF_SERVICE_ID from per_periods_of_service service

1500: and service.PERIOD_OF_SERVICE_ID = l_PERIOD_OF_SERVICE_ID
1501: order by sickness_start_date desc;
1502:
1503: Cursor POS_series(p_start_date date) is
1504: select PERIOD_OF_SERVICE_ID from per_periods_of_service service
1505: where PERSON_ID = p_person_id
1506: and p_start_date between DATE_START and nvl(service.actual_termination_date,hr_general.end_of_time);
1507:
1508: --12552547 End

Line 1617: l_PERIOD_OF_SERVICE_ID PER_PERIODS_OF_SERVICE.PERIOD_OF_SERVICE_ID%type;

1613: sickness_start_date >= p_start_date)
1614: order by sickness_start_date desc;
1615: */
1616:
1617: l_PERIOD_OF_SERVICE_ID PER_PERIODS_OF_SERVICE.PERIOD_OF_SERVICE_ID%type;
1618:
1619: cursor PIW_series(p_start_date date) is
1620: select sickness_start_date,
1621: sickness_end_date,

Line 1624: per_periods_of_service service

1620: select sickness_start_date,
1621: sickness_end_date,
1622: absence_attendance_id
1623: from per_absence_attendances per,
1624: per_periods_of_service service
1625: where per.person_id = p_person_id
1626: and per.sickness_start_date is not null
1627: and per.sickness_start_date < p_sickness_start_date
1628: and (p_start_date is null or

Line 1639: from per_periods_of_service service

1635: --
1636:
1637: Cursor POS_series(p_start_date date) is
1638: select PERIOD_OF_SERVICE_ID
1639: from per_periods_of_service service
1640: where PERSON_ID = p_person_id
1641: and p_start_date between DATE_START and nvl(service.actual_termination_date,hr_general.end_of_time);
1642:
1643: --12552547 End

Line 4175: -- PER_PERIODS_OF_SERVICE.

4171: procedure SSP1L_control (
4172: --
4173: -- If prior employment details are updated then we must recalculate SSP
4174: -- This procedure is called from the after update row-level trigger on
4175: -- PER_PERIODS_OF_SERVICE.
4176: --
4177: p_person_id in number,
4178: p_date_start in date
4179: ) is