APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_STOPPAGES

Line 492: from ssp_stoppages

488: --
489: -- 563202 - by concatenating null to reason_id forces a more efficient index
490: -- to be used.
491: select 1
492: from ssp_stoppages
493: where ((p_absence_attendance_id is not null
494: and p_absence_attendance_id = absence_attendance_id)
495: or (p_maternity_id is not null
496: and p_maternity_id = maternity_id))

Line 651: delete ssp_stoppages

647: if l_deleting and l_count < 1
648: then
649: hr_utility.set_location('ssp_del_orphaned_rows:'||l_proc,50);
650: --
651: delete ssp_stoppages
652: where maternity_id = each_maternity.maternity_id;
653: end if;
654: end loop;
655: --