APPS.BEN_CMD_SHD SQL Statements

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

Line: 74

    select
		cm_dlvry_med_typ_id,
	cm_dlvry_med_typ_cd,
	cm_dlvry_mthd_typ_id,
	rqd_flag,
	dflt_flag,
	business_group_id,
	cmd_attribute_category,
	cmd_attribute1,
	cmd_attribute2,
	cmd_attribute3,
	cmd_attribute4,
	cmd_attribute5,
	cmd_attribute6,
	cmd_attribute7,
	cmd_attribute8,
	cmd_attribute9,
	cmd_attribute10,
	cmd_attribute11,
	cmd_attribute12,
	cmd_attribute13,
	cmd_attribute14,
	cmd_attribute15,
	cmd_attribute16,
	cmd_attribute17,
	cmd_attribute18,
	cmd_attribute19,
	cmd_attribute20,
	cmd_attribute21,
	cmd_attribute22,
	cmd_attribute23,
	cmd_attribute24,
	cmd_attribute25,
	cmd_attribute26,
	cmd_attribute27,
	cmd_attribute28,
	cmd_attribute29,
	cmd_attribute30,
	object_version_number
    from	ben_cm_dlvry_med_typ
    where	cm_dlvry_med_typ_id = p_cm_dlvry_med_typ_id;

Line: 182

    select 	cm_dlvry_med_typ_id,
	cm_dlvry_med_typ_cd,
	cm_dlvry_mthd_typ_id,
	rqd_flag,
	dflt_flag,
	business_group_id,
	cmd_attribute_category,
	cmd_attribute1,
	cmd_attribute2,
	cmd_attribute3,
	cmd_attribute4,
	cmd_attribute5,
	cmd_attribute6,
	cmd_attribute7,
	cmd_attribute8,
	cmd_attribute9,
	cmd_attribute10,
	cmd_attribute11,
	cmd_attribute12,
	cmd_attribute13,
	cmd_attribute14,
	cmd_attribute15,
	cmd_attribute16,
	cmd_attribute17,
	cmd_attribute18,
	cmd_attribute19,
	cmd_attribute20,
	cmd_attribute21,
	cmd_attribute22,
	cmd_attribute23,
	cmd_attribute24,
	cmd_attribute25,
	cmd_attribute26,
	cmd_attribute27,
	cmd_attribute28,
	cmd_attribute29,
	cmd_attribute30,
	object_version_number
    from	ben_cm_dlvry_med_typ
    where	cm_dlvry_med_typ_id = p_cm_dlvry_med_typ_id
    for	update nowait;