APPS.BEN_YRP_SHD SQL Statements

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

Line: 78

    select
		yr_perd_id,
	perds_in_yr_num,
	perd_tm_uom_cd,
	perd_typ_cd,
	end_date,
	start_date,
	lmtn_yr_strt_dt,
	lmtn_yr_end_dt,
	business_group_id,
	yrp_attribute_category,
	yrp_attribute1,
	yrp_attribute2,
	yrp_attribute3,
	yrp_attribute4,
	yrp_attribute5,
	yrp_attribute6,
	yrp_attribute7,
	yrp_attribute8,
	yrp_attribute9,
	yrp_attribute10,
	yrp_attribute11,
	yrp_attribute12,
	yrp_attribute13,
	yrp_attribute14,
	yrp_attribute15,
	yrp_attribute16,
	yrp_attribute17,
	yrp_attribute18,
	yrp_attribute19,
	yrp_attribute20,
	yrp_attribute21,
	yrp_attribute22,
	yrp_attribute23,
	yrp_attribute24,
	yrp_attribute25,
	yrp_attribute26,
	yrp_attribute27,
	yrp_attribute28,
	yrp_attribute29,
	yrp_attribute30,
	object_version_number
    from	ben_yr_perd
    where	yr_perd_id = p_yr_perd_id;

Line: 189

    select 	yr_perd_id,
	perds_in_yr_num,
	perd_tm_uom_cd,
	perd_typ_cd,
	end_date,
	start_date,
	lmtn_yr_strt_dt,
	lmtn_yr_end_dt,
	business_group_id,
	yrp_attribute_category,
	yrp_attribute1,
	yrp_attribute2,
	yrp_attribute3,
	yrp_attribute4,
	yrp_attribute5,
	yrp_attribute6,
	yrp_attribute7,
	yrp_attribute8,
	yrp_attribute9,
	yrp_attribute10,
	yrp_attribute11,
	yrp_attribute12,
	yrp_attribute13,
	yrp_attribute14,
	yrp_attribute15,
	yrp_attribute16,
	yrp_attribute17,
	yrp_attribute18,
	yrp_attribute19,
	yrp_attribute20,
	yrp_attribute21,
	yrp_attribute22,
	yrp_attribute23,
	yrp_attribute24,
	yrp_attribute25,
	yrp_attribute26,
	yrp_attribute27,
	yrp_attribute28,
	yrp_attribute29,
	yrp_attribute30,
	object_version_number
    from	ben_yr_perd
    where	yr_perd_id = p_yr_perd_id
    for	update nowait;