APPS.SSP_MAT_BUS dependencies on SSP_MATERNITIES

Line 101: from ssp_maternities h

97: --
98: -- Get that the due date is unique for the person
99: --
100: select 1
101: from ssp_maternities h
102: where due_date = p_due_date
103: and person_id = p_person_id
104: and nvl(leave_type,'MA') = nvl(p_leave_type,'MA')
105: and maternity_id <> nvl(p_maternity_id,0);

Line 411: from ssp_maternities m

407: l_late_evidence BOOLEAN;
408: l_chk_date DATE;
409: cursor c1 is
410: select m.mpp_start_date
411: from ssp_maternities m
412: where m.maternity_id = p_maternity_id;
413: c1_rec c1%ROWTYPE;
414:
415: BEGIN