[Home] [Help]
2587: object_version_number,
2588: MPP_start_date,
2589: due_date, -- Need due_date to decide on value of sickness_trigger_weeks
2590: ssp_smp_pkg.expected_week_of_confinement(due_date) EWC
2591: from ssp_maternities
2592: where person_id = p_absence.person_id
2593: and nvl(leave_type,'MA') = 'MA';
2594:
2595: l_proc varchar2 (72) := g_package||'check_disqualifying_period';