APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on SSP_MATERNITIES

Line 318: from ssp_maternities

314: 'AB',ssp_apab_pkg.earliest_ASPPP_start_date(actual_birth_date),
315: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
316: ssp_smp_pkg.earliest_MPP_start_date (due_date))
317: earliest_MPP_start_date
318: from ssp_maternities
319: where maternity_id = p_maternity_id;
320: --
321: l_maternity csr_MPP%rowtype;
322: --

Line 407: from ssp_maternities

403: actual_birth_date,
404: partner_stat_pay_start_date,
405: partner_return_to_work,
406: partner_death_date
407: from ssp_maternities
408: where maternity_id = p_maternity_id;
409: --
410: l_maternity csr_MPP%rowtype;
411: l_default_MPP_start_date date := null;

Line 2846: from ssp_maternities h

2842: ) is
2843: --
2844: cursor c1 is
2845: select h.due_date, h.mpp_start_date
2846: from ssp_maternities h
2847: where h.maternity_id = p_maternity_id;
2848: --
2849: BEGIN
2850: open c1;

Line 2872: from ssp_maternities h

2868: --
2869: Function get_due_date (p_maternity_id in number) return date is
2870: cursor c1 is
2871: select h.due_date
2872: from ssp_maternities h
2873: where h.maternity_id = p_maternity_id;
2874: c1_rec c1%ROWTYPE;
2875: BEGIN
2876: open c1;

Line 2902: from ssp_maternities h

2898: counter number;
2899:
2900: cursor c1 is
2901: select h.due_date
2902: from ssp_maternities h
2903: where h.person_id = p_person_id
2904: and nvl(h.leave_type,'MA') = p_leave_type;
2905:
2906:

Line 2943: from ssp_maternities MAT

2939: Cursor csr_maternity is
2940: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2941: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2942: nvl(mat.leave_type,'MA') leave_type
2943: from ssp_maternities MAT
2944: where mat.maternity_id = p_maternity_id;
2945: --
2946: maternity csr_maternity%ROWTYPE;
2947: --

Line 2989: from ssp_maternities MAT

2985: select decode(mat.leave_type,
2986: 'AA',ssp_APAD_pkg.continuous_employment_date(mat.matching_date),
2987: 'AB',ssp_APAB_pkg.continuous_employment_date(mat.due_date)) continous_emp_date,
2988: person_id
2989: from ssp_maternities MAT
2990: where mat.maternity_id = p_maternity_id
2991: and mat.leave_type in ('AA','AB');
2992: --
2993: cursor period_of_service(l_person_id varchar2, continous_emp_date date) is

Line 3053: from ssp_maternities h

3049: --
3050: Procedure check_related_maternity (p_person_id in number) is
3051: cursor c1 is
3052: select h.rowid
3053: from ssp_maternities h
3054: where h.person_id = p_person_id;
3055: c1_rec c1%ROWTYPE;
3056: BEGIN
3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);