APPS.HR_PPU_SHD SQL Statements

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

Line: 73

    select
		purpose_usage_id,
	entity_name,
	pattern_purpose,
	hierarchy_level,
	object_version_number
    from	hr_pattern_purpose_usages
    where	purpose_usage_id = p_purpose_usage_id;

Line: 148

    select 	purpose_usage_id,
	entity_name,
	pattern_purpose,
	hierarchy_level,
	object_version_number
    from	hr_pattern_purpose_usages
    where	purpose_usage_id = p_purpose_usage_id
    for	update nowait;