APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_STOPPAGES

Line 451: from ssp_stoppages

447: --
448: -- 563202 - by concatenating null to reason_id forces a more efficient index
449: -- to be used.
450: select 1
451: from ssp_stoppages
452: where ((p_absence_attendance_id is not null
453: and p_absence_attendance_id = absence_attendance_id)
454: or (p_maternity_id is not null
455: and p_maternity_id = maternity_id))

Line 606: delete ssp_stoppages

602: if l_deleting and l_count < 1
603: then
604: hr_utility.set_location('ssp_del_orphaned_rows:'||l_proc,50);
605: --
606: delete ssp_stoppages
607: where maternity_id = each_maternity.maternity_id;
608: end if;
609: end loop;
610: --