DBA Data[Home] [Help]

APPS.BEN_PFF_SHD SQL Statements

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

Line: 73

    select
		pct_fl_tm_fctr_id,
	name,
	business_group_id,
	mx_pct_val,
	mn_pct_val,
	no_mn_pct_val_flag,
	no_mx_pct_val_flag,
	use_prmry_asnt_only_flag,
	use_sum_of_all_asnts_flag,
	rndg_cd,
	rndg_rl,
	pff_attribute_category,
	pff_attribute1,
	pff_attribute2,
	pff_attribute3,
	pff_attribute4,
	pff_attribute5,
	pff_attribute6,
	pff_attribute7,
	pff_attribute8,
	pff_attribute9,
	pff_attribute10,
	pff_attribute11,
	pff_attribute12,
	pff_attribute13,
	pff_attribute14,
	pff_attribute15,
	pff_attribute16,
	pff_attribute17,
	pff_attribute18,
	pff_attribute19,
	pff_attribute20,
	pff_attribute21,
	pff_attribute22,
	pff_attribute23,
	pff_attribute24,
	pff_attribute25,
	pff_attribute26,
	pff_attribute27,
	pff_attribute28,
	pff_attribute29,
	pff_attribute30,
	object_version_number
    from	ben_pct_fl_tm_fctr
    where	pct_fl_tm_fctr_id = p_pct_fl_tm_fctr_id;
Line: 186

    select 	pct_fl_tm_fctr_id,
	name,
	business_group_id,
	mx_pct_val,
	mn_pct_val,
	no_mn_pct_val_flag,
	no_mx_pct_val_flag,
	use_prmry_asnt_only_flag,
	use_sum_of_all_asnts_flag,
	rndg_cd,
	rndg_rl,
	pff_attribute_category,
	pff_attribute1,
	pff_attribute2,
	pff_attribute3,
	pff_attribute4,
	pff_attribute5,
	pff_attribute6,
	pff_attribute7,
	pff_attribute8,
	pff_attribute9,
	pff_attribute10,
	pff_attribute11,
	pff_attribute12,
	pff_attribute13,
	pff_attribute14,
	pff_attribute15,
	pff_attribute16,
	pff_attribute17,
	pff_attribute18,
	pff_attribute19,
	pff_attribute20,
	pff_attribute21,
	pff_attribute22,
	pff_attribute23,
	pff_attribute24,
	pff_attribute25,
	pff_attribute26,
	pff_attribute27,
	pff_attribute28,
	pff_attribute29,
	pff_attribute30,
	object_version_number
    from	ben_pct_fl_tm_fctr
    where	pct_fl_tm_fctr_id = p_pct_fl_tm_fctr_id
    for	update nowait;