[Home] [Help]
26: -- Get details of the initial paternity leave for a paternity
27: --
28: select absence.absence_attendance_id,
29: absence.date_start,
30: nvl (absence.date_end, hr_general.end_of_time) date_end,
31: absence.date_notification,
32: absence.accept_late_notification_flag
33: from
34: per_absence_attendances ABSENCE
60: maternity.partner_stat_pay_start_date, -- newly added columns
61: maternity.disrupted_placement_date death_of_child,
62: person.date_of_death,
63: service.date_start,
64: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
65: from ssp_maternities MATERNITY,
66: per_all_people_f PERSON,
67: per_periods_of_service SERVICE
68: where person.person_id = maternity.person_id
373: -- See header for description of this procedure.
374: --
375: no_prima_facia_entitlement exception;
376: invalid_absence_date exception;
377: l_work_start_date date := hr_general.end_of_time;
378: stoppage_end_date date := null;
379: no_of_absence_periods integer := 0;
380: l_proc varchar2(72) := g_package||'entitled_to_APAB';
381: l_keep_stoppages boolean default FALSE;
573: select 1
574: from per_periods_of_service
575: where person_id = person.person_id
576: and date_start <= ssp_APAB_pkg.continuous_employment_date(person.due_date)
577: and nvl (actual_termination_date, hr_general.end_of_time) >= person.QW;
578: --
579: l_dummy number (1);
580: l_proc varchar2 (72) := g_package||'check_continuity_rule';
581: --
914: --
915: /* if (absence.date_notification > (absence.date_start - (g_APAB_element.ASPP_NOTICE_REQUIREMENT * 7))
916: and absence.accept_late_notification_flag = 'N'
917: and (person.partner_date_of_death is null
918: or nvl(person.partner_date_of_death, hr_general.end_of_time) < add_months(person.actual_birth_date, 12))
919: )
920: then
921: -- Stop ASPPB payment. Need to verify is any end is required for this stoppage
922: create_stoppage (
1442: -- death and is prior to the period
1443: --
1444: and ((wre.reason <> employee_died
1445: and stp.withhold_from <= p_end_date
1446: and nvl (stp.withhold_to, hr_general.end_of_time)
1447: >= p_start_date)
1448: --
1449: or (wre.reason = employee_died
1450: and stp.withhold_from < p_start_date))