APPS.PER_ASP_SHD SQL Statements

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

Line: 59

    select
   sec_profile_assignment_id,
	user_id,
	security_group_id,
	business_group_id,
	security_profile_id,
	responsibility_id,
	responsibility_application_id,
	start_date,
	end_date,
	object_version_number
    from	per_sec_profile_assignments
    where	sec_profile_assignment_id = p_sec_profile_assignment_id;

Line: 139

    select 	sec_profile_assignment_id,
	user_id,
	security_group_id,
	business_group_id,
	security_profile_id,
	responsibility_id,
	responsibility_application_id,
	start_date,
	end_date,
	object_version_number
    from	per_sec_profile_assignments
    where	sec_profile_assignment_id = p_sec_profile_assignment_id
    for	update nowait;