APPS.SSP_PAB_PKG dependencies on HR_GENERAL

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

53: -- Get details of the initial paternity leave for a paternity
54: --
55: select absence.absence_attendance_id,
56: absence.date_start,
57: nvl (absence.date_end, hr_general.end_of_time) date_end,
58: absence.date_notification,
59: absence.accept_late_notification_flag
60: from
61: 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_PAB_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 ssp_maternities MATERNITY,
89: per_all_people_f PERSON,
90: per_periods_of_service SERVICE
91: where person.person_id = maternity.person_id

Line 349: l_work_start_date date := hr_general.end_of_time;

345: -- See header for description of this procedure.
346: --
347: no_prima_facia_entitlement exception;
348: invalid_absence_date exception;
349: l_work_start_date date := hr_general.end_of_time;
350: stoppage_end_date date := null;
351: no_of_absence_periods integer := 0;
352: l_proc varchar2(72) := g_package||'entitled_to_PAB';
353: l_keep_stoppages boolean default FALSE;

Line 548: and nvl (actual_termination_date, hr_general.end_of_time) >= person.QW;

544: select 1
545: from per_periods_of_service
546: where person_id = person.person_id
547: and date_start <= ssp_pab_pkg.continuous_employment_date(person.due_date)
548: and nvl (actual_termination_date, hr_general.end_of_time) >= person.QW;
549: --
550: l_dummy number (1);
551: l_proc varchar2 (72) := g_package||'check_continuity_rule';
552: --

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

977: (l_work_start_date),
978: p_withhold_to => ssp_smp_support_pkg.end_of_week
979: (absence.date_start -1));
980: --
981: if absence.date_end <> hr_general.end_of_time
982: then
983: l_work_start_date := absence.date_end + 1;
984: else
985: --

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

1474: -- death and is prior to the period
1475: --
1476: and ((wre.reason <> employee_died
1477: and stp.withhold_from <= p_end_date
1478: and nvl (stp.withhold_to, hr_general.end_of_time)
1479: >= p_start_date)
1480: --
1481: or (wre.reason = employee_died
1482: and stp.withhold_from < p_start_date))