APPS.HR_PAT_SHD SQL Statements

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

Line: 64

    select
		pattern_id,
	pattern_name,
	pattern_start_weekday,
	pattern_start_time,
	object_version_number
    from	hr_patterns
    where	pattern_id = p_pattern_id;

Line: 139

    select 	pattern_id,
	pattern_name,
	pattern_start_weekday,
	pattern_start_time,
	object_version_number
    from	hr_patterns
    where	pattern_id = p_pattern_id
    for	update nowait;