APPS.HR_PAE_SHD SQL Statements

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

Line: 84

    select
		exception_id,
	pattern_id,
	exception_name,
	exception_start_time,
	exception_end_time,
	exception_category,
	object_version_number
    from	hr_pattern_exceptions
    where	exception_id = p_exception_id;

Line: 163

    select 	exception_id,
	pattern_id,
	exception_name,
	exception_start_time,
	exception_end_time,
	exception_category,
	object_version_number
    from	hr_pattern_exceptions
    where	exception_id = p_exception_id
    for	update nowait;