APPS.SSP_SMP_PKG dependencies on HR_GENERAL

Line 185: nvl (absence.date_end, hr_general.end_of_time) date_end,

181: -- order of start date
182: --
183: select absence.absence_attendance_id,
184: absence.date_start,
185: nvl (absence.date_end, hr_general.end_of_time) date_end,
186: absence.date_notification,
187: absence.accept_late_notification_flag
188: from per_absence_attendances ABSENCE
189: where absence.maternity_id = p_maternity_id

Line 211: nvl (service.final_process_date, hr_general.end_of_time)

207: maternity.start_date_maternity_allowance,
208: maternity.pay_SMP_as_lump_sum,
209: person.date_of_death,
210: service.date_start,
211: nvl (service.final_process_date, hr_general.end_of_time)
212: FINAL_PROCESS_DATE
213: from ssp_maternities MATERNITY,
214: per_all_people_f PERSON,
215: per_periods_of_service SERVICE

Line 500: l_work_start_date date := hr_general.end_of_time;

496: -- See header for description of this procedure.
497: --
498: no_prima_facia_entitlement exception;
499: invalid_absence_date exception;
500: l_work_start_date date := hr_general.end_of_time;
501: stoppage_end_date date := null;
502: no_of_absence_periods integer := 0;
503: l_proc varchar2(72) := g_package||'entitled_to_SMP';
504: l_keep_stoppages boolean default FALSE;

Line 671: --and nvl (actual_termination_date, hr_general.end_of_time) -- BUG 3436510

667: from per_periods_of_service
668: where person_id = woman.person_id
669: );
670: -- 5210118 ends
671: --and nvl (actual_termination_date, hr_general.end_of_time) -- BUG 3436510
672: -- >= woman.QW;
673: --
674: l_dummy number (1);
675: l_proc varchar2 (72) := g_package||'check_continuity_rule';

Line 707: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date

703: --
704: -- retrieve period of service details relating to this maternity
705: --
706: cursor csr_period_of_service_qw is
707: select nvl(ser.actual_termination_date, hr_general.end_of_time) termination_date
708: ,leaving_reason leaving_reason
709: from per_periods_of_service ser
710: where ser.person_id = woman.person_id
711: and ssp_smp_pkg.continuous_employment_date(woman.due_date)

Line 712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);

708: ,leaving_reason leaving_reason
709: from per_periods_of_service ser
710: where ser.person_id = woman.person_id
711: and ssp_smp_pkg.continuous_employment_date(woman.due_date)
712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
713: --
714: l_proc varchar2(72) := g_package||'check_employment_qw';
715: l_termination_date per_periods_of_service.actual_termination_date%type;
716: l_leaving_reason hr_lookups.meaning%type;

Line 1195: and nvl(woman.actual_birth_date,hr_general.end_of_time) >= woman.due_date )

1191: -- BUG 3111736 Added to_number to make it compatible for 10g
1192: -- and there was no acceptable reason for the delay
1193: and absence.accept_late_notification_flag = 'N'
1194: -- and baby was not born prematurely
1195: and nvl(woman.actual_birth_date,hr_general.end_of_time) >= woman.due_date )
1196: then
1197: --
1198: -- Stop SMP payment from the start of the week in which the absence
1199: -- starts, to the end of the notice period

Line 1253: if absence.date_end <> hr_general.end_of_time

1249: (l_work_start_date),
1250: p_withhold_to => ssp_smp_support_pkg.end_of_week
1251: (absence.date_start -1));
1252: --
1253: if absence.date_end <> hr_general.end_of_time
1254: then
1255: l_work_start_date := absence.date_end + 1;
1256: else
1257: --

Line 1859: and nvl (stp.withhold_to, hr_general.end_of_time)

1855: -- death and is prior to the period
1856: --
1857: and ((wre.reason <> employee_died
1858: and stp.withhold_from <= p_end_date
1859: and nvl (stp.withhold_to, hr_general.end_of_time)
1860: >= p_start_date)
1861: --
1862: or (wre.reason = employee_died
1863: -- Bug 2663899