[Home] [Help]
188: -- order of start date
189: --
190: select absence.absence_attendance_id,
191: absence.date_start,
192: nvl (absence.date_end, hr_general.end_of_time) date_end,
193: absence.date_notification,
194: absence.accept_late_notification_flag
195: from per_absence_attendances ABSENCE
196: where absence.maternity_id = p_maternity_id
214: maternity.start_date_maternity_allowance,
215: maternity.pay_SMP_as_lump_sum,
216: person.date_of_death,
217: service.date_start,
218: nvl (service.final_process_date, hr_general.end_of_time)
219: FINAL_PROCESS_DATE
220: from ssp_maternities MATERNITY,
221: per_all_people_f PERSON,
222: per_periods_of_service SERVICE
503: -- See header for description of this procedure.
504: --
505: no_prima_facia_entitlement exception;
506: invalid_absence_date exception;
507: l_work_start_date date := hr_general.end_of_time;
508: stoppage_end_date date := null;
509: no_of_absence_periods integer := 0;
510: l_proc varchar2(72) := g_package||'entitled_to_SMP';
511: l_keep_stoppages boolean default FALSE;
674: from per_periods_of_service
675: where person_id = woman.person_id
676: );
677: -- 5210118 ends
678: --and nvl (actual_termination_date, hr_general.end_of_time) -- BUG 3436510
679: -- >= woman.QW;
680: --
681: l_dummy number (1);
682: l_proc varchar2 (72) := g_package||'check_continuity_rule';
710: --
711: -- retrieve period of service details relating to this maternity
712: --
713: cursor csr_period_of_service_qw is
714: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
715: ,leaving_reason leaving_reason
716: from per_periods_of_service ser
717: where ser.person_id = woman.person_id
718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
715: ,leaving_reason leaving_reason
716: from per_periods_of_service ser
717: where ser.person_id = woman.person_id
718: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
719: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
720: --
721: l_proc varchar2(72) := g_package||'check_employment_qw';
722: l_termination_date per_periods_of_service.actual_termination_date%type;
723: l_leaving_reason hr_lookups.meaning%type;
1206: -- BUG 3111736 Added to_number to make it compatible for 10g
1207: -- and there was no acceptable reason for the delay
1208: and absence.accept_late_notification_flag = 'N'
1209: -- and baby was not born prematurely
1210: and nvl(woman.actual_birth_date,hr_general.end_of_time) >= woman.due_date )
1211: then
1212: --
1213: -- Stop SMP payment from the start of the week in which the absence
1214: -- starts, to the end of the notice period
1298: --
1299: /*
1300: The assignment for l_work_start_date should happen for all rows hence moving this out of the if condition.
1301: --the last row which may or may not have end date.
1302: if absence.date_end <> hr_general.end_of_time
1303: then
1304: l_work_start_date := absence.date_end + 1;
1305: else
1306: */
1305: else
1306: */
1307:
1308: --Intermediate Absences for a single Maternity record cannot have end date as end of time
1309: if absence.date_end = hr_general.end_of_time and
1310: csr_absence_details%rowcount < no_of_absence_periods
1311: then
1312: --8470655 end
1313: --
1319: end if;
1320: end if;
1321:
1322: --8470655 Begin
1323: if absence.date_end <> hr_general.end_of_time
1324: then
1325: l_work_start_date := absence.date_end + 1;
1326: end if;
1327: --8470655 end
1934: -- death and is prior to the period
1935: --
1936: and ((wre.reason <> employee_died
1937: and stp.withhold_from <= p_end_date
1938: and nvl (stp.withhold_to, hr_general.end_of_time)
1939: >= p_start_date)
1940: --
1941: or (wre.reason = employee_died
1942: -- Bug 2663899