[Home] [Help]
1: package body SSP_PAB_PKG as
2: /*$Header: sppabapi.pkb 120.5 2006/12/09 16:41:34 kthampan noship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |
45: not to reference from per_absence_attendances
46: table
47: */
48: --------------------------------------------------------------------------------
49: g_package varchar2(33) := ' ssp_pab_pkg.'; -- Global package name
50: --
51: cursor csr_absence_details (p_maternity_id in number) is
52: --
53: -- Get details of the initial paternity leave for a paternity
71: -- Get details of the paternal person
72: --
73: select maternity.person_id,
74: maternity.due_date,
75: ssp_pab_pkg.qualifying_week (due_date) QW,
76: ssp_pab_pkg.expected_week_of_confinement (due_date) EWC,
77: maternity.maternity_id,
78: maternity.actual_birth_date,
79: maternity.live_birth_flag,
72: --
73: select maternity.person_id,
74: maternity.due_date,
75: ssp_pab_pkg.qualifying_week (due_date) QW,
76: ssp_pab_pkg.expected_week_of_confinement (due_date) EWC,
77: maternity.maternity_id,
78: maternity.actual_birth_date,
79: maternity.live_birth_flag,
80: maternity.start_date_with_new_employer,
543: --
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';
1748: hr_utility.set_location (l_proc,100);
1749: --
1750: end PAB_control;
1751: --------------------------------------------------------------------------------
1752: end ssp_pab_pkg;