DBA Data[Home] [Help]

APPS.BEN_LSF_SHD SQL Statements

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

Line: 77

    select
		los_fctr_id,
	name,
	business_group_id,
	los_det_cd,
	los_det_rl,
	mn_los_num,
	mx_los_num,
	no_mx_los_num_apls_flag,
	no_mn_los_num_apls_flag,
	rndg_cd,
	rndg_rl,
	los_dt_to_use_cd,
	los_dt_to_use_rl,
	los_uom,
        los_calc_rl,
        los_alt_val_to_use_cd,
	lsf_attribute_category,
	lsf_attribute1,
	lsf_attribute2,
	lsf_attribute3,
	lsf_attribute4,
	lsf_attribute5,
	lsf_attribute6,
	lsf_attribute7,
	lsf_attribute8,
	lsf_attribute9,
	lsf_attribute10,
	lsf_attribute11,
	lsf_attribute12,
	lsf_attribute13,
	lsf_attribute14,
	lsf_attribute15,
	lsf_attribute16,
	lsf_attribute17,
	lsf_attribute18,
	lsf_attribute19,
	lsf_attribute20,
	lsf_attribute21,
	lsf_attribute22,
	lsf_attribute23,
	lsf_attribute24,
	lsf_attribute25,
	lsf_attribute26,
	lsf_attribute27,
	lsf_attribute28,
	lsf_attribute29,
	lsf_attribute30,
	object_version_number,
	use_overid_svc_dt_flag
    from	ben_los_fctr
    where	los_fctr_id = p_los_fctr_id;
Line: 196

    select 	los_fctr_id,
	name,
	business_group_id,
	los_det_cd,
	los_det_rl,
	mn_los_num,
	mx_los_num,
	no_mx_los_num_apls_flag,
	no_mn_los_num_apls_flag,
	rndg_cd,
	rndg_rl,
	los_dt_to_use_cd,
	los_dt_to_use_rl,
	los_uom,
        los_calc_rl,
        los_alt_val_to_use_cd,
	lsf_attribute_category,
	lsf_attribute1,
	lsf_attribute2,
	lsf_attribute3,
	lsf_attribute4,
	lsf_attribute5,
	lsf_attribute6,
	lsf_attribute7,
	lsf_attribute8,
	lsf_attribute9,
	lsf_attribute10,
	lsf_attribute11,
	lsf_attribute12,
	lsf_attribute13,
	lsf_attribute14,
	lsf_attribute15,
	lsf_attribute16,
	lsf_attribute17,
	lsf_attribute18,
	lsf_attribute19,
	lsf_attribute20,
	lsf_attribute21,
	lsf_attribute22,
	lsf_attribute23,
	lsf_attribute24,
	lsf_attribute25,
	lsf_attribute26,
	lsf_attribute27,
	lsf_attribute28,
	lsf_attribute29,
	lsf_attribute30,
	object_version_number,
	use_overid_svc_dt_flag
    from	ben_los_fctr
    where	los_fctr_id = p_los_fctr_id
    for	update nowait;