[Home] [Help]
310: decode(leave_type,
311: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
312: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
313: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
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
389: decode(leave_type,
390: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
391: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
392: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
393: 'AB',ssp_apab_pkg.earliest_ASPPP_start_date(actual_birth_date),
394: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
395: ssp_smp_pkg.earliest_MPP_start_date (due_date))
396: earliest_MPP_start_date,
397: ssp_smp_pkg.qualifying_week (due_date) QW,
445:
446: select decode(l_maternity.partner_death_date,null,to_number (ele1.element_information12),to_number (ele1.element_information13))
447: into l_apl_max_weeks
448: from pay_element_types_f ele1
449: where ele1.element_name = ssp_apab_pkg.c_APAB_element_name
450: and l_maternity.due_date between ele1.effective_start_date
451: and ele1.effective_end_date;
452:
453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
2983: p_maternity_id in number) is
2984: Cursor csr_maternity is
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');