[Home] [Help]
302: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
303: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
304: ssp_smp_pkg.earliest_MPP_start_date (due_date))
305: earliest_MPP_start_date
306: from ssp_maternities
307: where maternity_id = p_maternity_id;
308: --
309: l_maternity csr_MPP%rowtype;
310: --
386: leave_type,
387: placement_date,
388: due_date,
389: actual_birth_date
390: from ssp_maternities
391: where maternity_id = p_maternity_id;
392: --
393: l_maternity csr_MPP%rowtype;
394: l_default_MPP_start_date date := null;
2737: ) is
2738: --
2739: cursor c1 is
2740: select h.due_date, h.mpp_start_date
2741: from ssp_maternities h
2742: where h.maternity_id = p_maternity_id;
2743: --
2744: BEGIN
2745: open c1;
2763: --
2764: Function get_due_date (p_maternity_id in number) return date is
2765: cursor c1 is
2766: select h.due_date
2767: from ssp_maternities h
2768: where h.maternity_id = p_maternity_id;
2769: c1_rec c1%ROWTYPE;
2770: BEGIN
2771: open c1;
2793: counter number;
2794:
2795: cursor c1 is
2796: select h.due_date
2797: from ssp_maternities h
2798: where h.person_id = p_person_id
2799: and nvl(h.leave_type,'MA') = p_leave_type;
2800:
2801:
2834: Cursor csr_maternity is
2835: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2836: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2837: nvl(mat.leave_type,'MA') leave_type
2838: from ssp_maternities MAT
2839: where mat.maternity_id = p_maternity_id;
2840: --
2841: maternity csr_maternity%ROWTYPE;
2842: --
2877: --
2878: Procedure check_related_maternity (p_person_id in number) is
2879: cursor c1 is
2880: select h.rowid
2881: from ssp_maternities h
2882: where h.person_id = p_person_id;
2883: c1_rec c1%ROWTYPE;
2884: BEGIN
2885: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);