APPS.SSP_STP_SHD SQL Statements

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

Line: 74

    select
		stoppage_id,
	object_version_number,
	absence_attendance_id,
	maternity_id,
	reason_id,
	user_entered,
	override_stoppage,
	employee_notified,
	withhold_from,
	withhold_to
    from	ssp_stoppages
    where	stoppage_id = p_stoppage_id;

Line: 154

    select 	stoppage_id,
	object_version_number,
	absence_attendance_id,
	maternity_id,
	reason_id,
	user_entered,
	override_stoppage,
	employee_notified,
	withhold_from,
	withhold_to
    from	ssp_stoppages
    where	stoppage_id = p_stoppage_id
    for	update nowait;