[Home] [Help]
1: package body SSP_PAB_PKG as
2: /*$Header: sppabapi.pkb 120.5.12010000.2 2009/07/27 13:56:00 npannamp ship $
3: +==============================================================================+
4: | Copyright (c) 1994 Oracle Corporation |
5: | Redwood Shores, California, USA |
48: fnd_date.chardate_to_date function in
49: the cursor csr_existing_entries.
50: */
51: --------------------------------------------------------------------------------
52: g_package varchar2(33) := ' ssp_pab_pkg.'; -- Global package name
53: --
54: cursor csr_absence_details (p_maternity_id in number) is
55: --
56: -- Get details of the initial paternity leave for a paternity
74: -- Get details of the paternal person
75: --
76: select maternity.person_id,
77: maternity.due_date,
78: ssp_pab_pkg.qualifying_week (due_date) QW,
79: ssp_pab_pkg.expected_week_of_confinement (due_date) EWC,
80: maternity.maternity_id,
81: maternity.actual_birth_date,
82: maternity.live_birth_flag,
75: --
76: select maternity.person_id,
77: maternity.due_date,
78: ssp_pab_pkg.qualifying_week (due_date) QW,
79: ssp_pab_pkg.expected_week_of_confinement (due_date) EWC,
80: maternity.maternity_id,
81: maternity.actual_birth_date,
82: maternity.live_birth_flag,
83: maternity.start_date_with_new_employer,
546: --
547: select 1
548: from per_periods_of_service
549: where person_id = person.person_id
550: and date_start <= ssp_pab_pkg.continuous_employment_date(person.due_date)
551: and nvl (actual_termination_date, hr_general.end_of_time) >= person.QW;
552: --
553: l_dummy number (1);
554: l_proc varchar2 (72) := g_package||'check_continuity_rule';
1757: hr_utility.set_location (l_proc,100);
1758: --
1759: end PAB_control;
1760: --------------------------------------------------------------------------------
1761: end ssp_pab_pkg;