[Home] [Help]
52: -- order of start date
53: --
54: select absence.absence_attendance_id,
55: absence.date_start,
56: nvl (absence.date_end, hr_general.end_of_time) date_end,
57: absence.date_notification,
58: absence.accept_late_notification_flag
59: from
60: per_absence_attendances ABSENCE
81: maternity.start_date_maternity_allowance,
82: maternity.pay_SMP_as_lump_sum pay_SAP_as_lump_sum,
83: person.date_of_death,
84: service.date_start,
85: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
86: from
87: ssp_maternities MATERNITY,
88: per_all_people_f PERSON,
89: per_periods_of_service SERVICE
315: -- See header for description of this procedure.
316: --
317: no_prima_facia_entitlement exception;
318: invalid_absence_date exception;
319: l_work_start_date date := hr_general.end_of_time;
320: stoppage_end_date date := null;
321: no_of_absence_periods integer := 0;
322: l_proc varchar2(72) := g_package||'entitled_to_SAP';
323: l_keep_stoppages boolean default FALSE;
479: from per_periods_of_service
480: where person_id = person.person_id
481: and date_start <= ssp_sap_pkg.continuous_employment_date
482: (person.matching_date)
483: and nvl (actual_termination_date, hr_general.end_of_time)
484: >= person.MW;
485: --
486: l_dummy number (1);
487: l_proc varchar2 (72) := g_package||'check_continuity_rule';
965: (l_work_start_date),
966: p_withhold_to => ssp_smp_support_pkg.end_of_week
967: (absence.date_start -1));
968: --
969: if absence.date_end <> hr_general.end_of_time
970: then
971: l_work_start_date := absence.date_end + 1;
972: else
973: --
1544: -- death and is prior to the period
1545: --
1546: and ((wre.reason <> employee_died
1547: and stp.withhold_from <= p_end_date
1548: and nvl (stp.withhold_to, hr_general.end_of_time)
1549: >= p_start_date)
1550: --
1551: or (wre.reason = employee_died
1552: and stp.withhold_from <= p_end_date))