DBA Data[Home] [Help]

APPS.BEN_AGF_SHD SQL Statements

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

Line: 79

    select
		age_fctr_id,
	name,
	mx_age_num,
	mn_age_num,
	age_uom,
	no_mn_age_flag,
	no_mx_age_flag,
        age_to_use_cd,
	age_det_cd,
	age_det_rl,
	rndg_cd,
	rndg_rl,
	age_calc_rl,
	business_group_id,
	agf_attribute_category,
	agf_attribute1,
	agf_attribute2,
	agf_attribute3,
	agf_attribute4,
	agf_attribute5,
	agf_attribute6,
	agf_attribute7,
	agf_attribute8,
	agf_attribute9,
	agf_attribute10,
	agf_attribute11,
	agf_attribute12,
	agf_attribute13,
	agf_attribute14,
	agf_attribute15,
	agf_attribute16,
	agf_attribute17,
	agf_attribute18,
	agf_attribute19,
	agf_attribute20,
	agf_attribute21,
	agf_attribute22,
	agf_attribute23,
	agf_attribute24,
	agf_attribute25,
	agf_attribute26,
	agf_attribute27,
	agf_attribute28,
	agf_attribute29,
	agf_attribute30,
	object_version_number
    from	ben_age_fctr
    where	age_fctr_id = p_age_fctr_id;
Line: 195

    select 	age_fctr_id,
	name,
	mx_age_num,
	mn_age_num,
	age_uom,
	no_mn_age_flag,
	no_mx_age_flag,
        age_to_use_cd,
	age_det_cd,
	age_det_rl,
	rndg_cd,
	rndg_rl,
	age_calc_rl,
	business_group_id,
	agf_attribute_category,
	agf_attribute1,
	agf_attribute2,
	agf_attribute3,
	agf_attribute4,
	agf_attribute5,
	agf_attribute6,
	agf_attribute7,
	agf_attribute8,
	agf_attribute9,
	agf_attribute10,
	agf_attribute11,
	agf_attribute12,
	agf_attribute13,
	agf_attribute14,
	agf_attribute15,
	agf_attribute16,
	agf_attribute17,
	agf_attribute18,
	agf_attribute19,
	agf_attribute20,
	agf_attribute21,
	agf_attribute22,
	agf_attribute23,
	agf_attribute24,
	agf_attribute25,
	agf_attribute26,
	agf_attribute27,
	agf_attribute28,
	agf_attribute29,
	agf_attribute30,
	object_version_number
    from	ben_age_fctr
    where	age_fctr_id = p_age_fctr_id
    for	update nowait;