DBA Data[Home] [Help]

APPS.BEN_CPY_SHD SQL Statements

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

Line: 69

    select
	popl_yr_perd_id,
	yr_perd_id,
	business_group_id,
	pl_id,
	pgm_id,
	ordr_num,
	acpt_clm_rqsts_thru_dt,
	py_clms_thru_dt,
	cpy_attribute_category,
	cpy_attribute1,
	cpy_attribute2,
	cpy_attribute3,
	cpy_attribute4,
	cpy_attribute5,
	cpy_attribute6,
	cpy_attribute7,
	cpy_attribute8,
	cpy_attribute9,
	cpy_attribute10,
	cpy_attribute11,
	cpy_attribute12,
	cpy_attribute13,
	cpy_attribute14,
	cpy_attribute15,
	cpy_attribute16,
	cpy_attribute17,
	cpy_attribute18,
	cpy_attribute19,
	cpy_attribute20,
	cpy_attribute21,
	cpy_attribute22,
	cpy_attribute23,
	cpy_attribute24,
	cpy_attribute25,
	cpy_attribute26,
	cpy_attribute27,
	cpy_attribute28,
	cpy_attribute29,
	cpy_attribute30,
	object_version_number
    from	ben_popl_yr_perd
    where	popl_yr_perd_id = p_popl_yr_perd_id;
Line: 179

    select 	popl_yr_perd_id,
	yr_perd_id,
	business_group_id,
	pl_id,
	pgm_id,
	ordr_num,
	acpt_clm_rqsts_thru_dt,
	py_clms_thru_dt,
	cpy_attribute_category,
	cpy_attribute1,
	cpy_attribute2,
	cpy_attribute3,
	cpy_attribute4,
	cpy_attribute5,
	cpy_attribute6,
	cpy_attribute7,
	cpy_attribute8,
	cpy_attribute9,
	cpy_attribute10,
	cpy_attribute11,
	cpy_attribute12,
	cpy_attribute13,
	cpy_attribute14,
	cpy_attribute15,
	cpy_attribute16,
	cpy_attribute17,
	cpy_attribute18,
	cpy_attribute19,
	cpy_attribute20,
	cpy_attribute21,
	cpy_attribute22,
	cpy_attribute23,
	cpy_attribute24,
	cpy_attribute25,
	cpy_attribute26,
	cpy_attribute27,
	cpy_attribute28,
	cpy_attribute29,
	cpy_attribute30,
	object_version_number
    from	ben_popl_yr_perd
    where	popl_yr_perd_id = p_popl_yr_perd_id
    for	update nowait;