[Home] [Help]
28: --
29: cursor csr_absence_details (p_maternity_id in number) is
30: select absence.absence_attendance_id,
31: absence.date_start,
32: nvl (absence.date_end, hr_general.end_of_time) date_end,
33: absence.date_notification,
34: absence.accept_late_notification_flag
35: from per_absence_attendances ABSENCE
36: where absence.maternity_id = p_maternity_id
61: maternity.partner_death_date partner_date_of_death, -- newly added columns
62: maternity.partner_stat_pay_start_date, -- newly added columns
63: person.date_of_death,
64: service.date_start,
65: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
66: from ssp_maternities MATERNITY,
67: per_all_people_f PERSON,
68: per_periods_of_service SERVICE
69: where person.person_id = maternity.person_id
330: -- See header for description of this procedure.
331: --
332: no_prima_facia_entitlement exception;
333: invalid_absence_date exception;
334: l_work_start_date date := hr_general.end_of_time;
335: stoppage_end_date date := null;
336: no_of_absence_periods integer := 0;
337: l_proc varchar2(72) := g_package||'entitled_to_APAD';
338: l_keep_stoppages boolean default FALSE;
529: from per_periods_of_service
530: where person_id = person.person_id
531: and date_start <= ssp_APAD_pkg.continuous_employment_date
532: (person.matching_date)
533: and nvl (actual_termination_date, hr_general.end_of_time)
534: >= person.MW;
535: --
536: l_dummy number (1);
537: l_proc varchar2 (72) := g_package||'check_continuity_rule';
841: --
842: /* if (absence.date_notification > (absence.date_start - (g_APAD_element.ASPP_NOTICE_REQUIREMENT * 7))
843: and absence.accept_late_notification_flag = 'N'
844: and (person.partner_date_of_death is null
845: or nvl(person.partner_date_of_death, hr_general.end_of_time) < add_months(person.placement_date, 12))
846: )
847: then
848: -- Stop ASPPA payment. Need to verify is any end is required for this stoppage
849: create_stoppage (
1360: -- death and is prior to the period
1361: --
1362: and ((wre.reason <> employee_died
1363: and stp.withhold_from <= p_end_date
1364: and nvl (stp.withhold_to, hr_general.end_of_time)
1365: >= p_start_date)
1366: --
1367: or (wre.reason = employee_died
1368: and stp.withhold_from < p_start_date))