DBA Data[Home] [Help]

APPS.BEN_CLA_SHD SQL Statements

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

Line: 83

    select
		cmbn_age_los_fctr_id,
	business_group_id,
	los_fctr_id,
	age_fctr_id,
	cmbnd_min_val,
	cmbnd_max_val,
	ordr_num,
	cla_attribute_category,
	cla_attribute1,
	cla_attribute2,
	cla_attribute3,
	cla_attribute4,
	cla_attribute5,
	cla_attribute6,
	cla_attribute7,
	cla_attribute8,
	cla_attribute9,
	cla_attribute10,
	cla_attribute11,
	cla_attribute12,
	cla_attribute13,
	cla_attribute14,
	cla_attribute15,
	cla_attribute16,
	cla_attribute17,
	cla_attribute18,
	cla_attribute19,
	cla_attribute20,
	cla_attribute21,
	cla_attribute22,
	cla_attribute23,
	cla_attribute24,
	cla_attribute25,
	cla_attribute26,
	cla_attribute27,
	cla_attribute28,
	cla_attribute29,
	cla_attribute30,
	object_version_number,
	name
    from	ben_cmbn_age_los_fctr
    where	cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id;
Line: 193

    select 	cmbn_age_los_fctr_id,
	business_group_id,
	los_fctr_id,
	age_fctr_id,
	cmbnd_min_val,
	cmbnd_max_val,
	ordr_num,
	cla_attribute_category,
	cla_attribute1,
	cla_attribute2,
	cla_attribute3,
	cla_attribute4,
	cla_attribute5,
	cla_attribute6,
	cla_attribute7,
	cla_attribute8,
	cla_attribute9,
	cla_attribute10,
	cla_attribute11,
	cla_attribute12,
	cla_attribute13,
	cla_attribute14,
	cla_attribute15,
	cla_attribute16,
	cla_attribute17,
	cla_attribute18,
	cla_attribute19,
	cla_attribute20,
	cla_attribute21,
	cla_attribute22,
	cla_attribute23,
	cla_attribute24,
	cla_attribute25,
	cla_attribute26,
	cla_attribute27,
	cla_attribute28,
	cla_attribute29,
	cla_attribute30,
	object_version_number,
	name
    from	ben_cmbn_age_los_fctr
    where	cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
    for	update nowait;