[Home] [Help]
56: -- Get details of the initial paternity leave for a paternity
57: --
58: select absence.absence_attendance_id,
59: absence.date_start,
60: nvl (absence.date_end, hr_general.end_of_time) date_end,
61: absence.date_notification,
62: absence.accept_late_notification_flag
63: from
64: per_absence_attendances ABSENCE
86: maternity.start_date_maternity_allowance,
87: maternity.pay_SMP_as_lump_sum pay_PAB_as_lump_sum,
88: person.date_of_death,
89: service.date_start,
90: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
91: from ssp_maternities MATERNITY,
92: per_all_people_f PERSON,
93: per_periods_of_service SERVICE
94: where person.person_id = maternity.person_id
348: -- See header for description of this procedure.
349: --
350: no_prima_facia_entitlement exception;
351: invalid_absence_date exception;
352: l_work_start_date date := hr_general.end_of_time;
353: stoppage_end_date date := null;
354: no_of_absence_periods integer := 0;
355: l_proc varchar2(72) := g_package||'entitled_to_PAB';
356: l_keep_stoppages boolean default FALSE;
547: select 1
548: from per_periods_of_service
549: where person_id = person.person_id
550: and date_start <= ssp_pab_pkg.continuous_employment_date(person.due_date)
551: and nvl (actual_termination_date, hr_general.end_of_time) >= person.QW;
552: --
553: l_dummy number (1);
554: l_proc varchar2 (72) := g_package||'check_continuity_rule';
555: --
980: (l_work_start_date),
981: p_withhold_to => ssp_smp_support_pkg.end_of_week
982: (absence.date_start -1));
983: --
984: if absence.date_end <> hr_general.end_of_time
985: then
986: l_work_start_date := absence.date_end + 1;
987: else
988: --
1483: -- death and is prior to the period
1484: --
1485: and ((wre.reason <> employee_died
1486: and stp.withhold_from <= p_end_date
1487: and nvl (stp.withhold_to, hr_general.end_of_time)
1488: >= p_start_date)
1489: --
1490: or (wre.reason = employee_died
1491: and stp.withhold_from < p_start_date))