APPS.HR_PAP_SHD SQL Statements

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

Line: 66

    select
		pattern_purpose_id,
	pattern_purpose,
	pattern_id,
	object_version_number
    from	hr_pattern_purposes
    where	pattern_purpose_id = p_pattern_purpose_id;

Line: 140

    select 	pattern_purpose_id,
	pattern_purpose,
	pattern_id,
	object_version_number
    from	hr_pattern_purposes
    where	pattern_purpose_id = p_pattern_purpose_id
    for	update nowait;