APPS.HR_EXU_SHD SQL Statements

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

Line: 101

    select
		exception_usage_id,
	exception_reason,
	calendar_id,
	calendar_usage_id,
	object_version_number,
	exception_id
    from	hr_exception_usages
    where	exception_usage_id = p_exception_usage_id;

Line: 179

    select 	exception_usage_id,
	exception_reason,
	calendar_id,
	calendar_usage_id,
	object_version_number,
	exception_id
    from	hr_exception_usages
    where	exception_usage_id = p_exception_usage_id
    for	update nowait;