APPS.SSP_MAT_BUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

	select p.sex
	from per_all_people_f p
	where p.person_id = p_person_id;

Line: 100

	select	1
	from	ssp_maternities h
	where	due_date = p_due_date
	and	person_id = p_person_id
        and     nvl(leave_type,'MA') = nvl(p_leave_type,'MA')
	and	maternity_id <> nvl(p_maternity_id,0);

Line: 252

select paa.sickness_start_date,
       paa.sickness_end_date
from   per_absence_attendances paa
where  paa.person_id = p_person_id
and    paa.pregnancy_related_illness = 'Y'
and    (p_ewc - 28) <= nvl(paa.sickness_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00'))
and    p_ewc >= paa.sickness_start_date;

Line: 410

    select m.mpp_start_date
    from   ssp_maternities m
    where  m.maternity_id = p_maternity_id;

Line: 451

    select evidence_date from ssp_medicals
     where maternity_id = p_maternity_id;

Line: 679

    select max(date_end) end_date
    from per_absence_attendances
    where maternity_id=p_rec.maternity_id;

Line: 755

Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 812

End insert_validate;

Line: 817

Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 864

End update_validate;

Line: 869

Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 881

End delete_validate;