APPS.SSP_SAP_PKG dependencies on HR_GENERAL

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

54: -- order of start date
55: --
56: select absence.absence_attendance_id,
57: absence.date_start,
58: nvl (absence.date_end, hr_general.end_of_time) date_end,
59: absence.date_notification,
60: absence.accept_late_notification_flag
61: from
62: per_absence_attendances ABSENCE

Line 87: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE

83: maternity.start_date_maternity_allowance,
84: maternity.pay_SMP_as_lump_sum pay_SAP_as_lump_sum,
85: person.date_of_death,
86: service.date_start,
87: nvl (service.final_process_date, hr_general.end_of_time) FINAL_PROCESS_DATE
88: from
89: ssp_maternities MATERNITY,
90: per_all_people_f PERSON,
91: per_periods_of_service SERVICE

Line 321: l_work_start_date date := hr_general.end_of_time;

317: -- See header for description of this procedure.
318: --
319: no_prima_facia_entitlement exception;
320: invalid_absence_date exception;
321: l_work_start_date date := hr_general.end_of_time;
322: stoppage_end_date date := null;
323: no_of_absence_periods integer := 0;
324: l_proc varchar2(72) := g_package||'entitled_to_SAP';
325: l_keep_stoppages boolean default FALSE;

Line 485: and nvl (actual_termination_date, hr_general.end_of_time)

481: from per_periods_of_service
482: where person_id = person.person_id
483: and date_start <= ssp_sap_pkg.continuous_employment_date
484: (person.matching_date)
485: and nvl (actual_termination_date, hr_general.end_of_time)
486: >= person.MW;
487: --
488: l_dummy number (1);
489: l_proc varchar2 (72) := g_package||'check_continuity_rule';

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

967: (l_work_start_date),
968: p_withhold_to => ssp_smp_support_pkg.end_of_week
969: (absence.date_start -1));
970: --
971: if absence.date_end <> hr_general.end_of_time
972: then
973: l_work_start_date := absence.date_end + 1;
974: else
975: --

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

1551: -- death and is prior to the period
1552: --
1553: and ((wre.reason <> employee_died
1554: and stp.withhold_from <= p_end_date
1555: and nvl (stp.withhold_to, hr_general.end_of_time)
1556: >= p_start_date)
1557: --
1558: or (wre.reason = employee_died
1559: and stp.withhold_from <= p_end_date))